Register and Join the most happening forum of Sikh community & intellectuals from around the world.
It is possible to set Caps Lock on when opening a database?
I have formated the fields and table etc to show all caps but when you edit
A 2nd option is to enter ">" in the format field in design view of the table.
> When a user enters data in a Access 2000...
When a user enters data in a Access 2000 database text field, how can I set
the text field to only allow upper case letters?
Let the user enter any text, and on the before update event of the field,
change it to upper case
Me.FieldName = Ucase(Me.FieldName)