Formatting table

[prkundan]

Iwant the "Name" field in my table to contain only capital letters. How to do it?

 

[stumac]

To display as capitals then you can change the fields format property within the table design to: >

With this approach the underlying data will still remain in the case entered (for a name this would usually be appropriate). To force it to store a capitals you would need to run an update query on the data already stored and also some kind of update as the data is entered (VBA on the form probably).

 

[prkundan]

To display as capitals then you can change the fields format property within the table design to: >

With this approach the underlying data will still remain in the case entered (for a name this would usually be appropriate). To force it to store a capitals you would need to run an update query on the data already stored and also some kind of update as the data is entered (VBA on the form probably).

Thanks a Lot! GOD BLESS YOU!!!!!