Datasheet caption for yes/no field can't be changed

D

Danny

Howdy.

I've got a couple of checkboxes on a form that displays in datasheet view. I
want to change the captions - the column headers - for those yes/no fields,
but none of my changes appear. I've edited the 'DatasheetCaption' attribute
for those form controls; I've entered a caption in the recordsource query;
and I've edited the Caption attribute in the table columns. The datasheet
column headers still show the literal field name rather than the text I've
assigned to the various Caption properties.

Can anyone point me in the right direction?

Thanks.
 
L

Linq Adams via AccessMonster.com

You've apparently edited the 'DatasheetCaption' attribute in the Properties
Sheet in Form Design View, and that will not affect how it is shown in a
Datasheet View Form.

You need to go into Design View for your ***table*** and enter whatever into
the Caption box there.
 
L

Linq Adams via AccessMonster.com

Sorry, I saw that you did it in the form but missed your doing it in the
table.

Don't know what to tell you; it works as it should in 2000 & 2003.

What version/service pack are you running?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top