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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Datasheet caption for yes/no field can't be changed
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. |
#2
|
|||
|
|||
Datasheet caption for yes/no field can't be changed
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. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201002/1 |
#3
|
|||
|
|||
Datasheet caption for yes/no field can't be changed
I did that already, as I mentioned in my original post. No go.
"Linq Adams via AccessMonster.com" wrote: 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. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201002/1 . |
#4
|
|||
|
|||
Datasheet caption for yes/no field can't be changed
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? -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201002/1 |
Thread Tools | |
Display Modes | |
|
|