[AccessD] Access 2013 Field Name Capitaliaation

Hi Charlotte,

I do not use prefixes for field names in tables.  However, I do use them for
table names and everything in the FE.  And, for any object in access which
carries the value of a field, I use the prefix + the name of the field.
Seems to work well - I can get into any older code and pretty quickly
understand what I was doing back then (not to say I still agree -but that's
a different story!).

And - always turn off Name AutoCorrect in options for the Current Database.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, February 17, 2014 3:57 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 2013 Field Name Capitaliaation

I'm working on my current contract and decided to use lower case prefixes on
field names (Access BE and FE) to indicate table or category of the value
and insure unique field names.  For some reason, Access keeps recapitalizing
the first character of the field names when I save, close, and reopen the
table in design view!  Has anyone else run into this?  I just spent several
hours lower casing prefixes only to discover after I ran a routine to
extract the field names that they had been recapitalized!
 I've fiddled with turning off Autocorrect, but that seems to do nothing
positive for me.

Any suggestions before I try shooting myself?

Charlotte
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com