[AccessD] Access 2013 Field Name Capitaliaation

jack drawbridge jackandpat.d at gmail.com
Mon Feb 17 19:01:56 CST 2014


Found this via Google (it's Office 2013 specific--includes Access)
I don't have 2013 so am unsure if it;s relevant.
http://office.microsoft.com/en-us/excel-help/automatically-correct-capitalization-HA010354276.aspx


On Mon, Feb 17, 2014 at 7:37 PM, Charlotte Foust
<charlotte.foust at gmail.com>wrote:

> 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
> >
> --
> 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