You can use Conditional Formatting to basically achieve the desired
effect. Make the area large enough to accomodate two TextBox controls
one for each Caption. Using CF, set the Backcolor of the TextBox to be
equal to the ForeColor(text) of the TextBox when you want it to be
invisible.
Set the TextBox props to mimic the look of a COmmandBUtton.
See the sample here:
http://www.lebans.com/conditionalformatting.htm
New Feb 08,2002. Added support for Datasheet view and SubForms.
A2KConditionalFormatting.zip is a sample MDB demonstrating how to
programmatically setup Conditional Formatting to simulate:
1) Highlighting of the Current Row for a Form in Continuous or Datasheet
View
2) Highlighting of Alternate Rows for a Form in Continuous or Datasheet
View
Version 2.7
Added sample demonstrating how to achieve a background
Hover/Highlighting of rows for a form in Continuous view.
Version 2.3
Added sample demonstrating how to achieve pseudo enable/disable of an
unbound control on a form in Continuous View.
Version 1.9
Added sample form to show how to apply conditional formatting to based
on a Boolean(Yes/No) field.
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"David" <da***@scene-double.co.uk> wrote in message
news:c1**************************@posting.google.c om...
Hi,
I need a button shown for each record (cont. form) with specific
captions on each.
I have a notes form for each record. When a user presses the button
they can read the notes. I want to display a caption on the button to
state either "Order Notes" or "READ NOTES".
I placed a label over the button, and depending if the notes field is
empty or not for each record the label should display the relevant
caption.
Which event should I place my code in for the to work on the form.
Form Load sets all captions for all records the same ?. Is the only
way to do this, to place an additional field in my table and change
that as per record ?
David