Change a field name

[Ray]

I tried to change the field name in a query using "New Name: [Field Name]".
It did not work at all and just display the caption of the Field Name. Is
it possible to change the field name or use a new caption in query?

Thanks,

Ray

 

[M.L. Sco Scofield]

Although aliasing a field will change the field name a form or report sees,
it will not change the caption if there is one coming from the table.

Query fields have their own captions that will override the caption coming
from the table.

In design view, right click the column in the grid and select Properties. At
the bottom of the list you will see Caption. Fill that in with your new
caption.

Good luck.

Sco

 

[Ray]

Sco,

Many thanks for your useful advice which resolves my issue.

Ray

Although aliasing a field will change the field name a form or report sees,
it will not change the caption if there is one coming from the table.

Query fields have their own captions that will override the caption coming
from the table.

In design view, right click the column in the grid and select Properties. At
the bottom of the list you will see Caption. Fill that in with your new
caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name: [Field Name]".
It did not work at all and just display the caption of the Field Name. Is
it possible to change the field name or use a new caption in query?

Thanks,

Ray

 

[M.L. Sco Scofield]

You're most welcome.

Sco

Sco,

Many thanks for your useful advice which resolves my issue.

Ray

Although aliasing a field will change the field name a form or report sees,
it will not change the caption if there is one coming from the table.

Query fields have their own captions that will override the caption coming
from the table.

In design view, right click the column in the grid and select

Properties.

At
the bottom of the list you will see Caption. Fill that in with your new
caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name: [Field Name]".
It did not work at all and just display the caption of the Field Name. Is
it possible to change the field name or use a new caption in query?

Thanks,

Ray

 

[Duane Hookom]

A good reason to avoid using the caption property of fields.

--
Duane Hookom
MS Access MVP

You're most welcome.

Sco

Sco,

Many thanks for your useful advice which resolves my issue.

Ray

Although aliasing a field will change the field name a form or report sees,
it will not change the caption if there is one coming from the table.

Query fields have their own captions that will override the caption coming
from the table.

In design view, right click the column in the grid and select

Properties.

At
the bottom of the list you will see Caption. Fill that in with your new
caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name: [Field
Name]".
It did not work at all and just display the caption of the Field

Name.
Is

it possible to change the field name or use a new caption in query?

Thanks,

Ray

 

[M.L. Sco Scofield]

No, no, no Duane!

Captions are GOOD!

They save tons of time when making forms and reports. You don't have to go
and edit label captions so that they look pretty.

And if you're using good naming practices, they are easy to tell apart.
If there's a space in it, it's a caption.
If there's no space in it, it's a field name.

People without good training, (i.e., *my* classes, put spaces in query
aliases. Bad. Aliases are to treated like field names. No spaces. To get a
pretty heading, you use the query field caption with spaces. Best of both
worlds!

My $.02 worth.

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

A good reason to avoid using the caption property of fields.

--
Duane Hookom
MS Access MVP

You're most welcome.

Sco

Sco,

Many thanks for your useful advice which resolves my issue.

Ray

Although aliasing a field will change the field name a form or report
sees,
it will not change the caption if there is one coming from the table.

Query fields have their own captions that will override the caption coming
from the table.

In design view, right click the column in the grid and select Properties.
At
the bottom of the list you will see Caption. Fill that in with your new
caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name: [Field
Name]".
It did not work at all and just display the caption of the Field Name.
Is
it possible to change the field name or use a new caption in query?

Thanks,

Ray

 

[Duane Hookom]

No, no, no Sco...
I don't mind adding the captions that I want in my forms and reports. Like
lookup fields, input masks, etc, I don't like seeing something in a
datasheet that isn't an actual field name or stored value.

To each his/her own.

--
Duane Hookom
MS Access MVP

No, no, no Duane!

Captions are GOOD!

They save tons of time when making forms and reports. You don't have to go
and edit label captions so that they look pretty.

And if you're using good naming practices, they are easy to tell apart.
If there's a space in it, it's a caption.
If there's no space in it, it's a field name.

People without good training, (i.e., *my* classes, put spaces in query
aliases. Bad. Aliases are to treated like field names. No spaces. To get a
pretty heading, you use the query field caption with spaces. Best of both
worlds!

My $.02 worth.

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

A good reason to avoid using the caption property of fields.

--
Duane Hookom
MS Access MVP

You're most welcome.

Sco

Sco,

Many thanks for your useful advice which resolves my issue.

Ray

Although aliasing a field will change the field name a form or report
sees,
it will not change the caption if there is one coming from the table.

Query fields have their own captions that will override the caption
coming
from the table.

In design view, right click the column in the grid and select
Properties.
At
the bottom of the list you will see Caption. Fill that in with

your
new

caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name: [Field
Name]".
It did not work at all and just display the caption of the Field Name.
Is
it possible to change the field name or use a new caption in query?

Thanks,

Ray

 

[tina]

i'm with you, Duane. when i look at a table, that's the one place i want to
see "the real thing" (remember the old Coke commercials? <g>).

No, no, no Sco...
I don't mind adding the captions that I want in my forms and reports. Like
lookup fields, input masks, etc, I don't like seeing something in a
datasheet that isn't an actual field name or stored value.

To each his/her own.

--
Duane Hookom
MS Access MVP

No, no, no Duane!

Captions are GOOD!

They save tons of time when making forms and reports. You don't have to go
and edit label captions so that they look pretty.

And if you're using good naming practices, they are easy to tell apart.
If there's a space in it, it's a caption.
If there's no space in it, it's a field name.

People without good training, (i.e., *my* classes, put spaces in query
aliases. Bad. Aliases are to treated like field names. No spaces. To get a
pretty heading, you use the query field caption with spaces. Best of both
worlds!

My $.02 worth.

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

A good reason to avoid using the caption property of fields.

--
Duane Hookom
MS Access MVP


You're most welcome.

Sco

Sco,

Many thanks for your useful advice which resolves my issue.

Ray

Although aliasing a field will change the field name a form or report
sees,
it will not change the caption if there is one coming from the table.

Query fields have their own captions that will override the caption
coming
from the table.

In design view, right click the column in the grid and select
Properties.
At
the bottom of the list you will see Caption. Fill that in with your
new
caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name: [Field
Name]".
It did not work at all and just display the caption of the Field
Name.
Is
it possible to change the field name or use a new caption in query?

Thanks,

Ray

 

[Duane Hookom]

Remember the old Bartles & James commercials... "we thank you for your
support"
Of course, we don't want to get Sco all upset. ;-)

--
Duane Hookom
MS Access MVP

i'm with you, Duane. when i look at a table, that's the one place i want to
see "the real thing" (remember the old Coke commercials? <g>).

No, no, no Sco...
I don't mind adding the captions that I want in my forms and reports. Like
lookup fields, input masks, etc, I don't like seeing something in a
datasheet that isn't an actual field name or stored value.

To each his/her own.

to

go

get

a

pretty heading, you use the query field caption with spaces. Best of both
worlds!

My $.02 worth.

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


A good reason to avoid using the caption property of fields.

--
Duane Hookom
MS Access MVP


You're most welcome.

Sco

Sco,

Many thanks for your useful advice which resolves my issue.

Ray

Although aliasing a field will change the field name a form or
report
sees,
it will not change the caption if there is one coming from the
table.

Query fields have their own captions that will override the caption
coming
from the table.

In design view, right click the column in the grid and select
Properties.
At
the bottom of the list you will see Caption. Fill that in with your
new
caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name:
[Field
Name]".
It did not work at all and just display the caption of the Field
Name.
Is
it possible to change the field name or use a new caption in
query?

Thanks,

Ray

 

[tina]

lol...are we dating ourselves here, or what? <g>
anyway, to each his own, as you said. i think i write a fairly solid db
structure myself, but if the average MVP (are any of you folks average?)
looked one over, i'd no doubt emerge from the review enlightened, as well as
humbled and perhaps slightly bloody. <shrug and smile>

Remember the old Bartles & James commercials... "we thank you for your
support"
Of course, we don't want to get Sco all upset. ;-)

--
Duane Hookom
MS Access MVP

i'm with you, Duane. when i look at a table, that's the one place i want to
see "the real thing" (remember the old Coke commercials? <g>).

No, no, no Sco...
I don't mind adding the captions that I want in my forms and reports. Like
lookup fields, input masks, etc, I don't like seeing something in a
datasheet that isn't an actual field name or stored value.

To each his/her own.

--
Duane Hookom
MS Access MVP


No, no, no Duane!

Captions are GOOD!

They save tons of time when making forms and reports. You don't have

to

go
and edit label captions so that they look pretty.

And if you're using good naming practices, they are easy to tell apart.
If there's a space in it, it's a caption.
If there's no space in it, it's a field name.

People without good training, (i.e., *my* classes, put spaces in query
aliases. Bad. Aliases are to treated like field names. No spaces. To

get

a
pretty heading, you use the query field caption with spaces. Best of both
worlds!

My $.02 worth.

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


A good reason to avoid using the caption property of fields.

--
Duane Hookom
MS Access MVP


You're most welcome.

Sco

Sco,

Many thanks for your useful advice which resolves my issue.

Ray

Although aliasing a field will change the field name a form or
report
sees,
it will not change the caption if there is one coming from the
table.

Query fields have their own captions that will override the
caption
coming
from the table.

In design view, right click the column in the grid and select
Properties.
At
the bottom of the list you will see Caption. Fill that in with
your
new
caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name:
[Field
Name]".
It did not work at all and just display the caption of the Field
Name.
Is
it possible to change the field name or use a new caption in
query?

Thanks,

Ray

 

[M.L. Sco Scofield]

Captions are *nothing* like lookup fields or input masks.

We'll just have to agree to disagree...

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

No, no, no Sco...
I don't mind adding the captions that I want in my forms and reports. Like
lookup fields, input masks, etc, I don't like seeing something in a
datasheet that isn't an actual field name or stored value.

To each his/her own.

--
Duane Hookom
MS Access MVP

No, no, no Duane!

Captions are GOOD!

They save tons of time when making forms and reports. You don't have to go
and edit label captions so that they look pretty.

And if you're using good naming practices, they are easy to tell apart.
If there's a space in it, it's a caption.
If there's no space in it, it's a field name.

People without good training, (i.e., *my* classes, put spaces in query
aliases. Bad. Aliases are to treated like field names. No spaces. To get a
pretty heading, you use the query field caption with spaces. Best of both
worlds!

My $.02 worth.

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

A good reason to avoid using the caption property of fields.

--
Duane Hookom
MS Access MVP


You're most welcome.

Sco

Sco,

Many thanks for your useful advice which resolves my issue.

Ray

Although aliasing a field will change the field name a form or report
sees,
it will not change the caption if there is one coming from the table.

Query fields have their own captions that will override the caption
coming
from the table.

In design view, right click the column in the grid and select
Properties.
At
the bottom of the list you will see Caption. Fill that in with your
new
caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name: [Field
Name]".
It did not work at all and just display the caption of the Field
Name.
Is
it possible to change the field name or use a new caption in query?

Thanks,

Ray

 

[M.L. Sco Scofield]

Well Tina,

I don't know you, but if you're going to side with Duane on this, then your
are respectfully disagreed with too...

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

i'm with you, Duane. when i look at a table, that's the one place i want to
see "the real thing" (remember the old Coke commercials? <g>).

No, no, no Sco...
I don't mind adding the captions that I want in my forms and reports. Like
lookup fields, input masks, etc, I don't like seeing something in a
datasheet that isn't an actual field name or stored value.

To each his/her own.

to

go

get

a

pretty heading, you use the query field caption with spaces. Best of both
worlds!

My $.02 worth.

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


A good reason to avoid using the caption property of fields.

--
Duane Hookom
MS Access MVP


You're most welcome.

Sco

Sco,

Many thanks for your useful advice which resolves my issue.

Ray

Although aliasing a field will change the field name a form or
report
sees,
it will not change the caption if there is one coming from the
table.

Query fields have their own captions that will override the caption
coming
from the table.

In design view, right click the column in the grid and select
Properties.
At
the bottom of the list you will see Caption. Fill that in with your
new
caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name:
[Field
Name]".
It did not work at all and just display the caption of the Field
Name.
Is
it possible to change the field name or use a new caption in
query?

Thanks,

Ray

 

[M.L. Sco Scofield]

Too late. U done already messed with me. Look out. Only 8 (maybe) months
till the summit...

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

Remember the old Bartles & James commercials... "we thank you for your
support"
Of course, we don't want to get Sco all upset. ;-)

--
Duane Hookom
MS Access MVP

i'm with you, Duane. when i look at a table, that's the one place i want to
see "the real thing" (remember the old Coke commercials? <g>).

No, no, no Sco...
I don't mind adding the captions that I want in my forms and reports. Like
lookup fields, input masks, etc, I don't like seeing something in a
datasheet that isn't an actual field name or stored value.

To each his/her own.

--
Duane Hookom
MS Access MVP


No, no, no Duane!

Captions are GOOD!

They save tons of time when making forms and reports. You don't have

to

go
and edit label captions so that they look pretty.

And if you're using good naming practices, they are easy to tell apart.
If there's a space in it, it's a caption.
If there's no space in it, it's a field name.

People without good training, (i.e., *my* classes, put spaces in query
aliases. Bad. Aliases are to treated like field names. No spaces. To

get

a
pretty heading, you use the query field caption with spaces. Best of both
worlds!

My $.02 worth.

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


A good reason to avoid using the caption property of fields.

--
Duane Hookom
MS Access MVP


You're most welcome.

Sco

Sco,

Many thanks for your useful advice which resolves my issue.

Ray

Although aliasing a field will change the field name a form or
report
sees,
it will not change the caption if there is one coming from the
table.

Query fields have their own captions that will override the
caption
coming
from the table.

In design view, right click the column in the grid and select
Properties.
At
the bottom of the list you will see Caption. Fill that in with
your
new
caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name:
[Field
Name]".
It did not work at all and just display the caption of the Field
Name.
Is
it possible to change the field name or use a new caption in
query?

Thanks,

Ray

 

[M.L. Sco Scofield]

....average MVP...

Oh Tina...

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

lol...are we dating ourselves here, or what? <g>
anyway, to each his own, as you said. i think i write a fairly solid db
structure myself, but if the average MVP (are any of you folks average?)
looked one over, i'd no doubt emerge from the review enlightened, as well as
humbled and perhaps slightly bloody. <shrug and smile>

Remember the old Bartles & James commercials... "we thank you for your
support"
Of course, we don't want to get Sco all upset. ;-)

--
Duane Hookom
MS Access MVP


want
to reports.
Like have
to To
get

form

or

report
sees,
it will not change the caption if there is one coming from the
table.

Query fields have their own captions that will override the
caption
coming
from the table.

In design view, right click the column in the grid and select
Properties.
At
the bottom of the list you will see Caption. Fill that in with
your
new
caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name:
[Field
Name]".
It did not work at all and just display the caption of the
Field
Name.
Is
it possible to change the field name or use a new

caption

in

 

[Lynn Trapp]

...but if the average MVP (are any of you folks average?)

looked one over, i'd no doubt emerge from the review enlightened, as well as
humbled and perhaps slightly bloody. <shrug and smile>

Tina,
Not being an MVP has nothing to do with coming out enlightened, humbled, and
bloody. We MVP's get our share of enlightment, humility, and bloodiness. <g>

 

[tina]

lol...well, at least i'm in good company, then! <g>

 

[tina]

silly me <g>

...average MVP...

Oh Tina...

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

lol...are we dating ourselves here, or what? <g>
anyway, to each his own, as you said. i think i write a fairly solid db
structure myself, but if the average MVP (are any of you folks average?)
looked one over, i'd no doubt emerge from the review enlightened, as

well

as
humbled and perhaps slightly bloody. <shrug and smile>

spaces

in

spaces.

To

Best

of

both
worlds!

My $.02 worth.

--

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1
gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com


A good reason to avoid using the caption property of fields.

--
Duane Hookom
MS Access MVP


You're most welcome.

Sco

Sco,

Many thanks for your useful advice which resolves my issue.

Ray

Although aliasing a field will change the field name a

form

or
report
sees,
it will not change the caption if there is one coming

from
the

table.

Query fields have their own captions that will override the
caption
coming
from the table.

In design view, right click the column in the grid and select
Properties.
At
the bottom of the list you will see Caption. Fill that

in
with

your
new
caption.

Good luck.

Sco

I tried to change the field name in a query using "New Name:
[Field
Name]".
It did not work at all and just display the caption of the
Field
Name.
Is
it possible to change the field name or use a new

caption

in
query?

Thanks,

Ray

 

[Lynn Trapp]

Yah, but you have to be careful about this company. They are hard to keep in
line.

 

[M.L. Sco Scofield]

Hey, I resemble that...

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com