Change a field name

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

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

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


"Lynn Trapp" wrote in message
...
...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

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

silly me g


"M.L. Sco Scofield" wrote in message
...
...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


"tina" wrote in message
...
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


"Duane Hookom" wrote in message
...
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


"tina" wrote in message
...
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).


"Duane Hookom" wrote in message
...
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


"M.L. Sco Scofield" wrote in message
...
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


"Duane Hookom" wrote in message
...
A good reason to avoid using the caption property of fields.

--
Duane Hookom
MS Access MVP


"M.L. Sco Scofield" wrote in message
...
You're most welcome.

Sco

"Ray" wrote in message
...
Sco,

Many thanks for your useful advice which resolves my
issue.

Ray

"M.L. Sco Scofield" wrote in message
...
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" wrote in message
...
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

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


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

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

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


"Lynn Trapp" wrote in message
...
lol...well, at least i'm in good company, then! g


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

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm