Re: Ampersand in Field Caption

Even in my early years of creating Access databases, I never created object
names with spaces or punctuation.
BTW: One of my resolutions for the new year is to stop lying ;-)

--
Duane Hookom
MS Access MVP
--

"Ken Hudson" <KenHudson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D65906EC-FFEB-416F-96CC-475339DC532B@xxxxxxxxxxxxxxxx
> Hi Duane,
> Possibly, but I would have to create a delete query to clear out the table
> first.
> I decided to bite the bullet and change the field name. It took a couple
> of
> hours yesterday and I may have missed a field reference somewhere but it
> will
> show up eventually.
> Next I should go in and change all the field names that have spaces in
> them.
> <bg>
> Thanks for all the suggestions.
> --
> Ken Hudson
>
>
> "Duane Hookom" wrote:
>
>> Can you use an Append query rather than a Make Table query?
>>
>> --
>> Duane Hookom
>> MS Access MVP
>> --
>>
>> "Ken Hudson" <KenHudson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:BF39AB04-DB2C-49BE-87DE-5FA85855DEE9@xxxxxxxxxxxxxxxx
>> >I was wondering when/if someone would ask that question.
>> > Short answer is that I developed this DB five years ago as a "rookie"
>> > and
>> > it
>> > has evolved into a rather large/complex DB. I realized a couple of
>> > years
>> > ago
>> > that the ampersand was a no-no, but didn't want to attempt to change
>> > all
>> > the
>> > references that involve this field.
>> > --
>> > Ken Hudson
>> >
>> >
>> > "Duane Hookom" wrote:
>> >
>> >> Why in the world are you attempting to create a field name with an
>> >> ampersand
>> >> in it? I recommend never exposing field names to users and feel an
>> >> ampersand
>> >> suggest expression concatenation.
>> >>
>> >> --
>> >> Duane Hookom
>> >> MS Access MVP
>> >> --
>> >>
>> >> "Ken Hudson" <KenHudson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:E439692C-AB7F-4A2B-9C92-66A9C525FBA6@xxxxxxxxxxxxxxxx
>> >> > Hi John,
>> >> > Tried that. I get an error messsage with brackets.
>> >> > --
>> >> > Ken Hudson
>> >> >
>> >> >
>> >> > "John Spencer" wrote:
>> >> >
>> >> >> Try surrounding it with brackets.
>> >> >> [Test&Caption]
>> >> >>
>> >> >>
>> >> >>
>> >> >> Ken Hudson wrote:
>> >> >> >
>> >> >> > Hi Joe,
>> >> >> > That seems to work in a select query, but in a make table query,
>> >> >> > it
>> >> >> > creates
>> >> >> > Test&&Caption.
>> >> >> > --
>> >> >> > Ken Hudson
>> >> >> >
>> >> >> > "Joe Cilinceon" wrote:
>> >> >> >
>> >> >> > > Ken Hudson wrote:
>> >> >> > > > I have a make table query in which I want to enter a field
>> >> >> > > > caption
>> >> >> > > > that contains an ampersand.
>> >> >> > > > When I save the query and re-open it, it inserts spaces
>> >> >> > > > around
>> >> >> > > > the
>> >> >> > > > ampersand.
>> >> >> > > >
>> >> >> > > > Test&Caption: [FieldName] becomes Test & Caption:
>> >> >> > > > [FieldName]
>> >> >> > > >
>> >> >> > > > How can I force the caption to remain as is?
>> >> >> > > >
>> >> >> > > > TIA.
>> >> >> > >
>> >> >> > > Enter the ampersand twice &&
>> >> >> > >
>> >> >> > > Test && Caption:[FieldName]
>> >> >> > > --
>> >> >> > >
>> >> >> > > Joe Cilinceon
>> >> >> > >
>> >> >> > >
>> >> >> > >
>> >> >> > >
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages