If I add a Yes/No column thus:
What do I need to do additionally so that when one opens the table for simple viewing the field appears as a "check-box"?Code:"ALTER TABLE Groups ADD Column OfferAlt YESNO False"
Formatting Yes/No field
Experienced Old Geezer
Windows 10 
Access 2013 32bit
If I add a Yes/No column thus:
What do I need to do additionally so that when one opens the table for simple viewing the field appears as a "check-box"?Code:"ALTER TABLE Groups ADD Column OfferAlt YESNO False"
Who is John Galt?
Windows XP Access 2007
I don't think you can get there with DDL alone. See the last post here:
http://www.utteraccess.com/forum/Add...-t1109178.html
Of course the sentiment of "who cares what it looks like in the table" applies.
Experienced Old Geezer
Windows 10 Access 2013 32bit
Hi Paul,
I don't really care. I had my focus on consistency. I have existing code from times gone by where I used an exact statement format to add a Yes/No field to a table column and subsequent viewing of the table showed a check-box without any overt action on my part. The current case code-wise is no different but for some reason the table viewing is different.
Moving on.............
Thanks,
Bill
Conditional Formatting - Comparing a Percent Field to a Text Field
Conditional formatting of a field when another field is=true
Posting Permissions
Reply With Quote