Force user to enter text in capitals....

[blondends]

Hi,

I have a quick question, How can I force the user to only enter text as capitals or automatically change any text entered to caps?

Thanks in advance,

Chris

 

[SarahG]

Use the input mask on the text box, > causes all characters that follow to be converted to uppercase.

 

[blondends]

Ah excellent, i was trying to put '>' in the format box but it didn't quite work properly. Thanks very much !!!

Chris

 

[TomHW]

If you don't wish to force the user to enter in all caps, you can easily add code in the AfterUpdate event behind the field to do it for you:
Me!txtEntry.Value = UCase(Me!txtEntry.Value)

Where txtEntry is the field you are setting to uppercase.

Hope this helps,
Tom

 

[blondends]

Yeah, that is better. Works a treat - it will be a bit easier doing it this was - end users will only get confused if asked to enter in U Case only.

Cheers,

Chris