Data Sheet View vs. Form View

[Shao]

I have a table Products with the following properties:

Field Names:
ProductPartNumber
ProductDescription
ProductPrice

Captions:
Product Part Number
product Description
Product Price

I created a form in "DataSheet View". When I open the
form in DataSheet View the headers have the Field Names
with no spaces. When I change the form over to "Form
View" the headers have the Captions with the spaces. It
looks like the DataSheet View doesn't use the text
labels. Instead it uses the actual field names for
headers. Is there a way to force the DataSheet View to
display headers with the captions/text label instead of
field names?

Thank you so much for your help.

 

[Conan Kelly]

Try setting the CAPTION property for each field to what
you want it to read in the DESIGN VIEW of the TABLE the
form is based on.

I think that might work for you.

Conan Kelly

 

[Shao]

I think you are talking the captions in LABEL FIELD in
DATASHEET VIEW. My captions are already set up in the
tables and carries over to the forms. The form has no
problem showing the captions when the form is in FORM VIEW
and DESIGN VIEW.

However, when the form is in DATASHEET VIEW the captions
don't show up. If you go to the properties of the TEXT
BOX in DESIGN VIEW you will not see an option for
CAPTIONS. In DATASHEET VIEW the captions/label fields
don't show and only the Name under the text property shows
up. I don't really want to change the Names. Maybe this
is just a DATASHEET VIEW default and there's no way around
it.

:-/

 

[Shao]

I found that if I change the Default View in properties to
Continous Forms the captions/label fields show up. The
format is similiar to DATASHEET VIEW. This might just work
for me.

 

[Brendan Reynolds \(MVP\)]

I tried to test this before posting, but I'm using Access 2003, and it looks
as though the default behaviour may have changed in Access 2003. When I
created a datasheet form in Access 2003, it displayed the captions in
datasheet view, I didn't have to change anything. But I do remember having
the problem you describe in earlier versions.

If you're creating a new datasheet form using the form wizard, just choose
Columnar instead of Datasheet when creating the form, then when the wizard
is finished, change the Default View property of the form to Datasheet and
the Allow Form View, Allow PivotTable View, and Allow PivotChart view to No,
and the form will be displayed in Datasheet view using the captions.

This next bit is the bit that I couldn't test in Access 2003, I'm going from
memory here, but I'm fairly sure about this - I believe that the reason a
form created using the wizard and selecting Datasheet in earlier versions of
Access doesn't use the captions is that the labels on the form are created
as stand-alone labels, they are not attached to the corresponding text boxes
or combo boxes.

To fix this, open the form in design view, select the label, and cut it to
the clipboard. Then select the control to which the label should be
attached, right-click that control, and choose paste. The label you cut to
the clipboard will be pasted to the form, and it will now be attached to the
selected text box or combo box, and used as the caption for that column in
datasheet view.