change color

  • Thread starter Thread starter retep
  • Start date Start date
R

retep

Hi all

I'm creating an invoice with a form and subform. The form contain the
customer information while the subform enable the user to choose the
product, unit and unit price. If the user had entered a product that
has not been previously purchased by the customer, I wanted to change
the color on the unit price to red. right now I use

Me![OrderDetail.Unit Price].ForeColor = RGB(255, 0, 0)

but it change all the Unit Prices on the order to red. How do I just
change the color of the unit price of the product that I'm currently
entering instead of all the unit prices. Thanks

Peter
 
Hi Peter,

Try:

IF [what ever control you are comparing] = "what ever value" THEN
Me![OrderDetail.Unit Price].ForeColor = RGB(255, 0, 0)
ELSE
Me![OrderDetail.Unit Price].ForeColor = "what ever the original color
was"
END IF


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."




--------------------
| From: (e-mail address removed) (retep)
| Newsgroups: microsoft.public.access.forms
| Subject: change color
| Date: 11 Feb 2004 12:31:01 -0800
| Organization: http://groups.google.com
| Lines: 15
| Message-ID: <[email protected]>
| NNTP-Posting-Host: 67.112.90.245
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1076531461 2440 127.0.0.1 (11 Feb 2004
20:31:01 GMT)
| X-Complaints-To: (e-mail address removed)
| NNTP-Posting-Date: Wed, 11 Feb 2004 20:31:01 +0000 (UTC)
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.su
l.t-online.de!t-online.de!newsfeed.gamma.ru!Gamma.RU!news.maxwell.syr.edu!po
stnews1.google.com!not-for-mail
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.forms:254775
| X-Tomcat-NG: microsoft.public.access.forms
|
| Hi all
|
| I'm creating an invoice with a form and subform. The form contain the
| customer information while the subform enable the user to choose the
| product, unit and unit price. If the user had entered a product that
| has not been previously purchased by the customer, I wanted to change
| the color on the unit price to red. right now I use
|
| Me![OrderDetail.Unit Price].ForeColor = RGB(255, 0, 0)
|
| but it change all the Unit Prices on the order to red. How do I just
| change the color of the unit price of the product that I'm currently
| entering instead of all the unit prices. Thanks
|
| Peter
|
 
Back
Top