Note Notification

J

John Cantrell

I have a database with two tabs in a form. On the second tab I have a notes
field. The form opens up on the first tab where it is not immediately
obvious if there is a notes on the second tab or not.

Is there anything I can put on the first page (text box, different colour or
tick box for example) that will notify the user that there is a note on the
second tab?

Many thanks for any help!!
 
T

Tom van Stiphout

On Tue, 2 Sep 2008 06:17:01 -0700, John Cantrell

In the Form_Current event you could test that Notes field to see if it
has any data, and if non-zero change the color. Something like:
Me.somecontrol.BackColor = iif(IsNull(Me.txtNotes), vbGreen, vbRed)

-Tom.
Microsoft Access MVP
 
J

John Cantrell

Alright!!! I was just asking!

I appreciate the post tells me where it goes and I am grateful for Toms
help. However as I am new to Access I don't specifically where that is.
Could you explain please?
 
J

John W. Vinson

Thank you very much.

Where do I input that bit of formula?
Click to expand...

Open the Form in design view. View its Properties. One of them is the
"Current" event; click the ... icon by it and choose "Code Builder". Access
will give you a Sub and End Sub line; put the code in between (changing
somecontrol to the name of the control that you want to change color).
 
J

John Cantrell

Thank you very much indeed!!

John W. Vinson said:
Open the Form in design view. View its Properties. One of them is the
"Current" event; click the ... icon by it and choose "Code Builder". Access
will give you a Sub and End Sub line; put the code in between (changing
somecontrol to the name of the control that you want to change color).
Click to expand...
 
Top