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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old February 6th, 2010, 08:11 PM posted to microsoft.public.access.forms
Danny
external usenet poster
 
Posts: 385
Default 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  
Old February 6th, 2010, 10:03 PM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default 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  
Old February 6th, 2010, 10:47 PM posted to microsoft.public.access.forms
Danny
external usenet poster
 
Posts: 385
Default 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  
Old February 7th, 2010, 02:56 AM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default 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

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 07:09 PM.


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