Input mask for textbox

  • Thread starter Thread starter Mark
  • Start date Start date
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<???????????????????????
Click to expand...

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

Any helpers?

Mark
 
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
Click to expand...
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
 
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
 
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



.
Click to expand...
 
Back
Top