Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / May 2008

Tip: Looking for answers? Try searching our database.

add caption

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
blue3509 - 09 May 2008 18:56 GMT
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 ?
Jeff Boyce - 09 May 2008 19:08 GMT
?More homework?!

Use the caption property.

Regards

Jeff Boyce
Microsoft Office/Access MVP

> 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 ?
blue3509 - 09 May 2008 19:33 GMT
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..

> ?More homework?!
>
[quoted text clipped - 11 lines]
> > 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 ?
Jeff Boyce - 09 May 2008 20:06 GMT
The caption property holds the literal string of what you want for ... the
caption.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

> your missing the point   i know use the caption property...  i just dont
> know
[quoted text clipped - 21 lines]
>> > caption
>> > last name , first name.      any one know  how to add the caption ?
blue3509 - 09 May 2008 20:24 GMT
i need  examples... of what your talking about i   have no idea what you mean
by  literal string........

> The caption property holds the literal string of what you want for ... the
> caption.
[quoted text clipped - 31 lines]
> >> > caption
> >> > last name , first name.      any one know  how to add the caption ?
George Nicholson - 09 May 2008 21:14 GMT
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.

Signature

HTH,
George

>i need  examples... of what your talking about i   have no idea what you
>mean
[quoted text clipped - 38 lines]
>> >> > caption
>> >> > last name , first name.      any one know  how to add the caption ?
John W. Vinson - 09 May 2008 23:00 GMT
>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.
Signature


            John W. Vinson [MVP]

fredg - 09 May 2008 20:14 GMT
> 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
[quoted text clipped - 17 lines]
>>> 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.
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Jeff Boyce - 09 May 2008 23:39 GMT
My pappy taught me not to get into a ... contest with a ...

Jeff <G!>

>> your missing the point   i know use the caption property...  i just dont
>> know
[quoted text clipped - 25 lines]
> I guess you should have paid more attention in grade school.
> You would have known Access by now.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.