A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

add caption



 
 
Thread Tools Display Modes
  #1  
Old May 9th, 2008, 06:56 PM posted to microsoft.public.access.tablesdbdesign
blue3509
external usenet poster
 
Posts: 7
Default add caption

any one know the proper way to add caption to a field name? the field name
is Employee Name


the question ask type in the field Employee Name than add the caption
last name , first name. any one know how to add the caption ?
  #2  
Old May 9th, 2008, 07:08 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default add caption

?More homework?!

Use the caption property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"blue3509" wrote in message
...
any one know the proper way to add caption to a field name? the field
name
is Employee Name


the question ask type in the field Employee Name than add the caption
last name , first name. any one know how to add the caption ?



  #3  
Old May 9th, 2008, 07:33 PM posted to microsoft.public.access.tablesdbdesign
blue3509
external usenet poster
 
Posts: 7
Default add caption

your missing the point i know use the caption property... i just dont know
what to put in the caption. i am not sure just typing last name first
name in the property will work.....

i guess i need someone who knows access really well.. thanks anyways..

"Jeff Boyce" wrote:

?More homework?!

Use the caption property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"blue3509" wrote in message
...
any one know the proper way to add caption to a field name? the field
name
is Employee Name


the question ask type in the field Employee Name than add the caption
last name , first name. any one know how to add the caption ?




  #4  
Old May 9th, 2008, 08:06 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default add caption

The caption property holds the literal string of what you want for ... the
caption.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"blue3509" wrote in message
...
your missing the point i know use the caption property... i just dont
know
what to put in the caption. i am not sure just typing last name
first
name in the property will work.....

i guess i need someone who knows access really well.. thanks anyways..

"Jeff Boyce" wrote:

?More homework?!

Use the caption property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"blue3509" wrote in message
...
any one know the proper way to add caption to a field name? the
field
name
is Employee Name


the question ask type in the field Employee Name than add the
caption
last name , first name. any one know how to add the caption ?






  #5  
Old May 9th, 2008, 08:14 PM posted to microsoft.public.access.tablesdbdesign
fredg
external usenet poster
 
Posts: 4,386
Default add caption

On Fri, 9 May 2008 11:33:06 -0700, blue3509 wrote:

your missing the point i know use the caption property... i just dont know
what to put in the caption. i am not sure just typing last name first
name in the property will work.....

i guess i need someone who knows access really well.. thanks anyways..

"Jeff Boyce" wrote:

?More homework?!

Use the caption property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"blue3509" wrote in message
...
any one know the proper way to add caption to a field name? the field
name
is Employee Name


the question ask type in the field Employee Name than add the caption
last name , first name. any one know how to add the caption ?




Gee, Jeff,
I guess you should have paid more attention in grade school.
You would have known Access by now.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #6  
Old May 9th, 2008, 08:24 PM posted to microsoft.public.access.tablesdbdesign
blue3509
external usenet poster
 
Posts: 7
Default add caption

i need examples... of what your talking about i have no idea what you mean
by literal string........

"Jeff Boyce" wrote:

The caption property holds the literal string of what you want for ... the
caption.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"blue3509" wrote in message
...
your missing the point i know use the caption property... i just dont
know
what to put in the caption. i am not sure just typing last name
first
name in the property will work.....

i guess i need someone who knows access really well.. thanks anyways..

"Jeff Boyce" wrote:

?More homework?!

Use the caption property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"blue3509" wrote in message
...
any one know the proper way to add caption to a field name? the
field
name
is Employee Name


the question ask type in the field Employee Name than add the
caption
last name , first name. any one know how to add the caption ?






  #7  
Old May 9th, 2008, 09:14 PM posted to microsoft.public.access.tablesdbdesign
George Nicholson
external usenet poster
 
Posts: 791
Default add caption

Per Help (rephrased a little):
"...Field captions specify 1) the text for labels that will be attached to
controls created by dragging a field from the field list while designing
forms and 2) serves as the column heading for the field in either table or
query Datasheet view..."

The Caption property is Optional. *IF* there is one, the Caption value will
appear in place of the field name as stated above. If there is no caption
the Field name will appear.

Why?
Examples: a lot of developers don't like spaces in field names, or they like
to preface the name with characters that tell them what type of field it is,
or use abbreviations in field names, etc.

Therefore, field names like:

EmployeeName
sngHourlyRate
SSN
fldNotes

Valid field names from a developer's point of view, but they are candidates
for "user friendly" captions like:

Employee Name
Hourly Rate
Social Security Number
Notes and Comments

The "user friendly" captions appear in place of the "developer friendly"
field names in the situations stated above.

--
HTH,
George


"blue3509" wrote in message
...
i need examples... of what your talking about i have no idea what you
mean
by literal string........

"Jeff Boyce" wrote:

The caption property holds the literal string of what you want for ...
the
caption.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"blue3509" wrote in message
...
your missing the point i know use the caption property... i just
dont
know
what to put in the caption. i am not sure just typing last name
first
name in the property will work.....

i guess i need someone who knows access really well.. thanks
anyways..

"Jeff Boyce" wrote:

?More homework?!

Use the caption property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"blue3509" wrote in message
...
any one know the proper way to add caption to a field name? the
field
name
is Employee Name


the question ask type in the field Employee Name than add the
caption
last name , first name. any one know how to add the caption ?








  #8  
Old May 9th, 2008, 11:00 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default add caption

On Fri, 9 May 2008 12:24:00 -0700, blue3509
wrote:

i need examples... of what your talking about i have no idea what you mean
by literal string........


Open the table in design view.
Select the field.
Look at the lower left of the screen.
If you type

This Is My Caption

in the Caption property of the field then you will see

This Is My Caption

as the caption of the field.

Insulting people who are trying to help you, and obviously asking to be
spoonfed answers so that you can avoid thinking or studying, is just going to
get you killfiled by the volunteers here. I'm of two minds whether to send
this... but be assured it's the first AND LAST time I'll spoon feed you.
--

John W. Vinson [MVP]
  #9  
Old May 9th, 2008, 11:39 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default add caption

My pappy taught me not to get into a ... contest with a ...

Jeff G!
"fredg" wrote in message
...
On Fri, 9 May 2008 11:33:06 -0700, blue3509 wrote:

your missing the point i know use the caption property... i just dont
know
what to put in the caption. i am not sure just typing last name
first
name in the property will work.....

i guess i need someone who knows access really well.. thanks anyways..

"Jeff Boyce" wrote:

?More homework?!

Use the caption property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"blue3509" wrote in message
...
any one know the proper way to add caption to a field name? the
field
name
is Employee Name


the question ask type in the field Employee Name than add the
caption
last name , first name. any one know how to add the caption ?



Gee, Jeff,
I guess you should have paid more attention in grade school.
You would have known Access by now.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:06 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.