[RESOLVED] Access 2000 Table format

[jmhfloor]

Is there a way to format an existing database to make everything dispaly text witht he first letter of every word caps like this example.

Joe Smith
New Horizon
Access Database

[Static]

i think the only thing u can do is format for all upper or all lower using < or > in the format field

VBA/VB has StrConv(String,vbProperCase) which does what u need, but will not work in the format property...
you may need to try to do in the form display...