Conditional Formatting of Command Button Based on Data in a Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that has a command button that opens a "notes" form. The
person I'm creating this form for asked if there was some way to have the
button caption be another color if there are already notes in the table
driving the "notes" form. Can I do that with a command button, or will I
have to use a text box?
 
You can use the ForeColor property of the command button to change the color
of the caption. What I can't determine from your post is whethter you mean
any notes in the recordset at all or just notes for the current record.
 
Back
Top