Default ot upper case

[ronh42]

How do I get a column to default to upper case?

 

[MichaelintheUK]

Hello Ron

In table design you can use > in the Format property but this is just a format - it does not change the underlying data. I think you would have to remember to use the format in all your reports.

I use the UCASE$ function in a form's text box afterupdate event

e.g. where a textbox has the name txtPostcode the code would be

txtPostcode=UCASE$(txtPostcode)

Thanks

Michael

 

[ronh42]

Thanks, I can make it work.