Formating

[BroJames]

I have Access Office 2000 Premium. WinXP home, 1.2Ghz with 512MB memory.

Isn't there a way to format a field so that the first letter is Capitalized
even though it may have been entered as all lowercase letters.

I.E.,

entered: auto format:
john John
John John
JOHN John

I tried to use >L<?????????????? but in the field it changed everything to
L?????????????? and when I went back to check the field data it had changed
the formula to ><"L???????????????"

What do I need to do?

 

[Van T. Dinh]

Check Access Help for the differences between Format Property and InputMask
Property.

What you posted looks like the syntax for InputMask rather than Format.

I am not sure whether you want to retain the values as entered and simply
displayed with first letter of each word capitalised or you want to *update*
the Field values so that the stored value only has the first letter of each
word capitalised.

You will need to use the StrConv function to do this conversion for format
or update. For example:

?StrConv("abcd efgh", vbProperCase)
Abcd Efgh

?StrConv("ABCD EFGH", vbProperCase)
Abcd Efgh

If you want to use StrConv in a Query, vbProperCase is not recognised so you
need to use its literal value 3 like:

ProperCaseVal: StrConv([RequiredField], 3)