Formatting Text

[Chris Burke]

Helloooo!

I am wondering if Access 2000 has a function similar to
the WORKSHEET function Proper() whereby text is formatted
to a capitalised first letter and the rest are lowercase.

If there is not, does anyone know of a method of doing
this (say in Access 2000 VBscript) so that I can
automatically format data as it is imported into the
database.

Thanks very much!

 

[Arvin Meyer]

The StrConv() function is used to capitalize the first letter of every word.

StrConv([txtBoxName], vbProperCase)

While it may be diffcult to pre-format your text, it's simple to run an
update query after it's in the table Paste this into a SQL window after
changing the appropriate names:

UPDATE MyTable SET MyTable.FieldName = StrConv([FieldName],3);
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Chris Burke]

Thanks very much!!!

-----Original Message-----
The StrConv() function is used to capitalize the first letter of every word.

StrConv([txtBoxName], vbProperCase)

While it may be diffcult to pre-format your text, it's simple to run an
update query after it's in the table Paste this into a SQL window after
changing the appropriate names:

UPDATE MyTable SET MyTable.FieldName = StrConv ([FieldName],3);
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Helloooo!

I am wondering if Access 2000 has a function similar to
the WORKSHEET function Proper() whereby text is formatted
to a capitalised first letter and the rest are lowercase.

If there is not, does anyone know of a method of doing
this (say in Access 2000 VBscript) so that I can
automatically format data as it is imported into the
database.

Thanks very much!

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 8/12/2003


.