i need a check case function module for access

D

dbennett

I want to be able to auto correct upper and lower case in feilds on a form in
access
i have tried 2 methods of strings found in help fields here however neither
option works.
Some of this more technical stuff is a bit beyond me, however if I am shown
or explained I would greatley appreciate any help!, Thanks
 
S

Steve Schapel

Dbennett,

Most likely it will be best to write some simple code on the After
Update event of the control in question. For example, to make
everything upper case, youe code would look like this...
Me.NameOfControl = UCase(Me.NameOfControl)

If you need more explicit help with this, please let us know more
details of what you want to achieve. Examples would help.
 
D

dbennett

thanks, its not whole words i want in upper case its first name and surname
in the proper case ie D Bennett as opposed to d bennett
 
S

Steve Schapel

D Bennett

Ok, then like this...
Me.NameOfControl = StrConv(Me.NameOfControl, 3)

Note, however, that this may lead to some undesired results, for example
JoAnne McDonald will be Joanne Mcdonald and Leonardo da Vinci will be
changed to Leonardo Da Vinci.
 
D

dbennett

ok, so if i enter that string in the after update of the properties for each
feild, thisshould work?, or have i confused my modules with strings?...i am
soo rusty, havent done this sort of thing for 2 years, thanks for your
patience! :)
 
S

Steve Schapel

D Bennett,

In design view of the form, select one of the textboxes in question,
open the Properties sheet, and locate the After Update property. Enter
[Event Procedure], and then click the little button to the right with
the ellipsis [...] icon. This will open the Visual Basic Editor window,
with the cursor already placed in the right spot. Enter the code I gave
you (substituting, of course, the actual name of your control. Let me
know how that goes.
 
D

dbennett

YAY!!! it worked!, thank you so much!...so simple! i cant beleive it ha ha.
mwah! thanks again

Steve Schapel said:
D Bennett,

In design view of the form, select one of the textboxes in question,
open the Properties sheet, and locate the After Update property. Enter
[Event Procedure], and then click the little button to the right with
the ellipsis [...] icon. This will open the Visual Basic Editor window,
with the cursor already placed in the right spot. Enter the code I gave
you (substituting, of course, the actual name of your control. Let me
know how that goes.

--
Steve Schapel, Microsoft Access MVP

ok, so if i enter that string in the after update of the properties for each
feild, thisshould work?, or have i confused my modules with strings?...i am
soo rusty, havent done this sort of thing for 2 years, thanks for your
patience! :)
Click to expand...
Click to expand...
 
S

Steve Schapel

Well it's nice to know that the little things in life can still bring so
much joy! :)
 
Top