i need a check case function module for access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dbennett - 29 Dec 2005 00:03 GMT

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

Reply to this Message

Steve Schapel - 29 Dec 2005 00:27 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> 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

Reply to this Message

dbennett - 29 Dec 2005 01:08 GMT

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

> Dbennett,
>
[quoted text clipped - 12 lines]
> > 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

Reply to this Message

Steve Schapel - 29 Dec 2005 01:16 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> 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

Reply to this Message

dbennett - 29 Dec 2005 01:35 GMT

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! :)

> D Bennett
>
[quoted text clipped - 7 lines]
> > 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

Reply to this Message

Steve Schapel - 29 Dec 2005 03:02 GMT

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.

Signature

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! :)

Reply to this Message

dbennett - 29 Dec 2005 03:42 GMT

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

> D Bennett,
>
[quoted text clipped - 10 lines]
> > soo rusty, havent done this sort of thing for 2 years, thanks for your
> > patience! :)

Reply to this Message

Steve Schapel - 29 Dec 2005 04:02 GMT

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

Signature

Steve Schapel, Microsoft Access MVP

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

Reply to this Message