Ampersand in Field Caption

[Guest]

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.

 

[Joe Cilinceon]

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]

 

[Guest]

Hi Joe,
That seems to work in a select query, but in a make table query, it creates
Test&&Caption.
--
Ken Hudson

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]

 

[John Spencer]

Try surrounding it with brackets.
[Test&Caption]

Hi Joe,
That seems to work in a select query, but in a make table query, it creates
Test&&Caption.
--
Ken Hudson

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]

 

[Guest]

Hi John,
Tried that. I get an error messsage with brackets.
--
Ken Hudson

Try surrounding it with brackets.
[Test&Caption]

Hi Joe,
That seems to work in a select query, but in a make table query, it creates
Test&&Caption.
--
Ken Hudson

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]

 

[Duane Hookom]

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

Hi John,
Tried that. I get an error messsage with brackets.
--
Ken Hudson

Try surrounding it with brackets.
[Test&Caption]

Hi Joe,
That seems to work in a select query, but in a make table query, it
creates
Test&&Caption.
--
Ken Hudson

:

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]

 

[Guest]

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

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

Hi John,
Tried that. I get an error messsage with brackets.
--
Ken Hudson

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

:

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]

 

[Duane Hookom]

Can you use an Append query rather than a Make Table query?

--
Duane Hookom
MS Access MVP
--

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

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

Hi John,
Tried that. I get an error messsage with brackets.
--
Ken Hudson


:

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

:

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]

 

[Guest]

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

Can you use an Append query rather than a Make Table query?

--
Duane Hookom
MS Access MVP
--

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

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

Hi John,
Tried that. I get an error messsage with brackets.
--
Ken Hudson


:

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

:

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]

 

[Duane Hookom]

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

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

Can you use an Append query rather than a Make Table query?

--
Duane Hookom
MS Access MVP
--

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


:

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

Hi John,
Tried that. I get an error messsage with brackets.
--
Ken Hudson


:

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

:

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]