Hello everyone,

I'd like the text in current record to change to red, if the user selects
Yes under Priority field.  Obviously i have to put the code in the After
Update event of that combo box, but my attempt did not work, here's the
code, any suggestions would be greatly appreciated !

Vlad

--------------------------------------------------------
Private Sub cboPriority_AfterUpdate()

      If cboPriority.Value = "Yes" Then
              Me.CurrentRecord.Text.ForeColor = 255
      End If

End Sub



*******************Confidentiality and Privilege Notice*******************

This email is intended only to be read or used by the addressee. 
It is confidential and may contain legally privileged information. 
If you are not the addressee indicated in this message (or 
responsible for delivery of the message to such person), you 
may not copy or deliver this message to anyone, and you should 
destroy this message and kindly notify the sender by reply email. 
Confidentiality and legal privilege are not waived or lost by
reason of mistaken delivery to you.

Qantas Airways Limited
ABN 16 009 661 901

Visit Qantas online at http://www.qantas.com.au

You may wish to look into conditional formatting

-----Original Message-----
From: Vlad VRA09 Rakic [mailto:vrakic@q...]
Sent: Wednesday, 12 March 2003 1:49 PM
To: Access
Subject: [access] changing the colour of text in current record


Hello everyone,

I'd like the text in current record to change to red, if the user selects
Yes under Priority field.  Obviously i have to put the code in the After
Update event of that combo box, but my attempt did not work, here's the
code, any suggestions would be greatly appreciated !

Vlad

--------------------------------------------------------
Private Sub cboPriority_AfterUpdate()

      If cboPriority.Value = "Yes" Then
              Me.CurrentRecord.Text.ForeColor = 255
      End If

End Sub



*******************Confidentiality and Privilege Notice*******************

This email is intended only to be read or used by the addressee. 
It is confidential and may contain legally privileged information. 
If you are not the addressee indicated in this message (or 
responsible for delivery of the message to such person), you 
may not copy or deliver this message to anyone, and you should 
destroy this message and kindly notify the sender by reply email. 
Confidentiality and legal privilege are not waived or lost by
reason of mistaken delivery to you.

Qantas Airways Limited
ABN 16 009 661 901

Visit Qantas online at http://www.qantas.com.au



IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.