S Skymgr Mar 11, 2004 #1 Is there a way of making the text fields appear as Proper Case even if the text is typed in all caps or lower case? Thanks
Is there a way of making the text fields appear as Proper Case even if the text is typed in all caps or lower case? Thanks
R RobFMS Mar 11, 2004 #2 Here is one suggestion: make all the text lower case, using LCase() function. Then (see link) Strings: Capitalize first character of every word automatically http://www.mvps.org/access/strings/str0005.htm -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Here is one suggestion: make all the text lower case, using LCase() function. Then (see link) Strings: Capitalize first character of every word automatically http://www.mvps.org/access/strings/str0005.htm -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
J John Vinson Mar 11, 2004 #3 Is there a way of making the text fields appear as Proper Case even if the text is typed in all caps or lower case? Thanks Click to expand... You can run an Update query updating the field to StrConv([fieldname], 3) Note that this will turn a perfectly correct name like "MacDonald" into "Macdonald", and "van der Steen" into "Van Der Steen".
Is there a way of making the text fields appear as Proper Case even if the text is typed in all caps or lower case? Thanks Click to expand... You can run an Update query updating the field to StrConv([fieldname], 3) Note that this will turn a perfectly correct name like "MacDonald" into "Macdonald", and "van der Steen" into "Van Der Steen".
