If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Input Mask
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!! |
#2
|
|||
|
|||
Input Mask
|
#3
|
|||
|
|||
Input Mask
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 wrote in message 6... (Sara Lorence) wrote in m: 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 |
#4
|
|||
|
|||
Input Mask
|
Thread Tools | |
Display Modes | |
|
|