[AccessD] Access 2013 Field Name Capitaliaation

John C,
ROTFLMAO,

There's also stick your head in the gas oven for 15 minutes; drive
blindfolded on the interstate; ....


On Mon, Feb 17, 2014 at 5:30 PM, Dan Waters <df.waters at comcast.net> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>