P
Peter Hibbs
Hi All
I am creating a Yes/No field using VBA/SQL :-
db.Execute "ALTER TABLE [MyTableName] ADD [MyFieldName] YESNO"
which works fine. However, although the field functions correctly as a
Boolean field,
in the table it displays as a Text field (showing 0 or -1) instead of the
normal Check Box.
If I look at the properties for the field (on the Lookup tab) the Display
Control field shows Text Box.
If I change this to Check Box the field then displays as a Check Box.
Is there any way to set this property using VBA code (Yes I know the end
user would never see the table data
but it is more 'user friendly' to see a Check Box when I am testing). I have
tried changing the Format property
to Yes/No but this has no effect on how the field is displayed.
I am creating a Yes/No field using VBA/SQL :-
db.Execute "ALTER TABLE [MyTableName] ADD [MyFieldName] YESNO"
which works fine. However, although the field functions correctly as a
Boolean field,
in the table it displays as a Text field (showing 0 or -1) instead of the
normal Check Box.
If I look at the properties for the field (on the Lookup tab) the Display
Control field shows Text Box.
If I change this to Check Box the field then displays as a Check Box.
Is there any way to set this property using VBA code (Yes I know the end
user would never see the table data
but it is more 'user friendly' to see a Check Box when I am testing). I have
tried changing the Format property
to Yes/No but this has no effect on how the field is displayed.