Input Mask

[Sara Lorence]

I am new at creating an Access 2000 database from scratch. I am
trying to make 3 fields be entered in in caps only. I have looked at
many of the postings and tried what other people have suggested and I
have not gotten anything to work. If some one could please help me, I
would greatly appreciate it. The one that I have tried that made the
entry caps was doing an input mask but the program with that was it
was forcing me to determine how many characters had to be entered.
This did not work well because if I wrote and query (say for an
address) then there were extra spaces in the state and country fields.
Thanks in advance!!

 

[Tim Ferguson]

(e-mail address removed) (Sara Lorence) wrote in

I am new at creating an Access 2000 database from scratch. I am
trying to make 3 fields be entered in in caps only.

Put something like this in the BeforeUpdate event for the text boxes on the
form (you are doing all your data entry via a form, aren't you?):-

If Not IsNull(txtThisTextBox.Value) Then
txtThisTextBox.Value = UCase$(txtThisTextBox.Value)
End If

Hope that helps


Tim F

 

[Sara Lorence]

I tried this and I get the same error as before when I tried to create
an event procedure, no matter what I enter it tells me that it is
incorrent. Thanks anyways!!

Sara

 

[Tim Ferguson]

(e-mail address removed) (Sara Lorence) wrote in

I tried this and I get the same error as before when I tried to create
an event procedure, no matter what I enter it tells me that it is
incorrent. Thanks anyways!!

What error are you getting _exactly_?


Tim F