Forms

[dr223]

Hi,

How can I fix data populated in a field on a form to be capital letters always. Therefore, it is always displayed on Caps ...

Thanks

 

[neileg]

You could use an input mask to force the user to use capitals, or use StrConv in the after update event of the text box to convert the input to upper case.

 

[dr223]

What i want to do really is, even if the user is using small letters. The typed appears capital on the field and stored like so. So regardless, what the user uses small/capital letters. What will be shown and recorded on the form and table, respectively will be data in caps. Hope am clear.....


Taaah

 

[neileg]

It would be a bit fiddly to do this letter by letter, so I would use StrConv after the user has input the data.

 

[dr223]

Sorry, am new to access how do u use StrConv after update event......

Thanks

 

[neileg]

Lookup the function in Access help, first.

Every control in a form has events associated with it. You can use these events to trigger VBA code. The After Update event is the one that occurs any time the user enters data into the control. You can find this in the control properties sheet.

I would do you an example but our helpful IT people have broken my Access installation!

 

[dr223]

Thanks neileg sorted!!!