Text box issue

[bdhtexas]

I have a form that has two text boxes.

We want the data entered in these text boxes to be in ALL CAPS.

I entered an Input Mask, however, there is a limit of 250 characters for a mask, even though these are Memo fields and can have more than 250 characters entered in these boxes when the masks are not entered.

Is there a way I can have ALL CAPS and more than 250 characters in these two text boxes???

Thanks,
Brian

 

[Malcy]

Hi
Why not forget the input mask and allow users to enter their data as it comes and then before you close the form run a quick line that goes something like
.textbox1 = UCase(.textbox1)
.textbox2 = UCase(.textbox2)
That should convert it all to upper case. There may well be another way to do it but this one is very simple and that always helps I find.
HTH
Best wishes

Malcy

 

[bdhtexas]

One problem though, we update several records before we close a form, would it go back and convert all of them when we close the form?