Access

[Guest]

How do I get access to change the first letter to uppercase in a table.

 

[Guest]

Hi Dave

To ensure names are places correctly in the first place:-
In a Table use this as your input mask

L<??????????????????

To get just the first letter and make it a capital (for use in letters ect)
In a query add a new field use this
Capital: Left([NameField],1)

Press F1 to get more info

Hope this helps

 

[John Vinson]

How do I get access to change the first letter to uppercase in a table.

Be careful what you ask for. If you're doing this with people's names,
you'll get incorrect names such as Macphee instead of MacPhee, Van der
steen instead of van der Steen, O'brian instead of O'Brian.

But to permanently convert the field to first letter capital, rest
lower case, regardless of the current casing, use an Update query;
update the field to

UCase(Left([fieldname], 1)) & LCase(Mid([fieldname], 2))

To update it to Proper Case (Each Word Capitalized, Including
Macdonald And Van Der Steen), update to

StrConv([fieldname], 3)

John W. Vinson[MVP]

 

[Guest]

Cheers Wayne,

works like a treat.

Dave

Hi Dave

To ensure names are places correctly in the first place:-
In a Table use this as your input mask

L<??????????????????

To get just the first letter and make it a capital (for use in letters ect)
In a query add a new field use this
Capital: Left([NameField],1)

Press F1 to get more info

Hope this helps



--
Wayne
Manchester, England.

How do I get access to change the first letter to uppercase in a table.

 

[cfr20010910]

we

Cheers Wayne,

works like a treat.

Dave

Hi Dave

To ensure names are places correctly in the first place:-
In a Table use this as your input mask

L<??????????????????

To get just the first letter and make it a capital (for use in letters ect)
In a query add a new field use this
Capital: Left([NameField],1)

Press F1 to get more info

Hope this helps



--
Wayne
Manchester, England.

How do I get access to change the first letter to uppercase in a

table.