Input mask for textbox

M

Mark

I am using Access 97 and have a form with a textbox for
Firstnames.

Can someone tell me please the Input mask formula for this
textbox.

At present I am using
L<???????????????????????

So this only works properly when a person only has one
firstname and only capitalises the first letter eg;
Mark andrew

Any helpers?

Mark
 
B

Bas Cost Budde

Mark said:
I am using Access 97 and have a form with a textbox for
Firstnames.

Can someone tell me please the Input mask formula for this
textbox.

At present I am using



So this only works properly when a person only has one
firstname and only capitalises the first letter eg;
Mark andrew
Maybe you're better off changing the value after update (or before
update, I keep forgetting which one) with the StrConv function (see
Help) using vbProperCase
 
J

John Viescas

You're better of not using an Input Mask and using a bit of code instead.
In the AfterUpdate event of the text box, call the StrConv function to fix
it:

Me!txtFirstName = StrConv(Me!txtFirstName, vbProperCase)

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
 
M

Mark

Brilliant, thanks


Mark
-----Original Message-----
You're better of not using an Input Mask and using a bit of code instead.
In the AfterUpdate event of the text box, call the StrConv function to fix
it:

Me!txtFirstName = StrConv(Me!txtFirstName, vbProperCase)

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR? pg=personal&fr_id=1090&px=1434411



.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top