[AccessD] Access 2013 Field Name Capitaliaation

Charlotte Foust charlotte.foust at gmail.com
Mon Feb 17 18:37:12 CST 2014


Wise guy!  I'm like a bulldog, I get my teeth into something and won't let
go.  There must be some reason it saves some of the changes but not most of
them!  I don't usually name fields like this but on this project I have to
leave as many breadcrumbs and balls of string as possible for the
non-programmers who will maintain it.

Charlotte


On Mon, Feb 17, 2014 at 2:17 PM, John W Colby <jwcolby at gmail.com> wrote:

> Give up and accept that Microsoft knows best?  Mail cat feces to everyone
> at Microsoft?  Follow Arthur to another database product entirely?  Take up
> Yoga and consider your navel?  Copious quantities of attitude enhancing
> drugs?
>
> All of those suggestions are better than shooting yourself.
>
> ;)
>
> John W. Colby
>
> Reality is what refuses to go away
> when you do not believe in it
>
>
> On 2/17/2014 4:57 PM, Charlotte Foust wrote:
>
>> 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
>


More information about the AccessD mailing list