By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

programming colorcode in forms

P: n/a
Hi,

I tray to made a programming code for a form based on a table tblUpdate.

tblUpdate contain following fields:
Idnr
colorcode = number (1,2,3 or 4)

When in a simple form based on tblUpdate, i should like to see that all
records with colorcode value 1 are schowed in red, all records with
colorcode 2 are blue ect...
I haved tested with
Me!colorcode.forcolor = (rgb,255,0,0) bud it doest'n work.

I tray to find a solution based on programming code with vba. thanks anyway

Eddy,
Feb 19 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Feb 19, 3:54 pm, "flower1" <ecarnot...@skynet.bewrote:
Hi,

I tray to made a programming code for a form based on a table tblUpdate.

tblUpdate contain following fields:
Idnr
colorcode = number (1,2,3 or 4)

When in a simple form based on tblUpdate, i should like to see that all
records with colorcode value 1 are schowed in red, all records with
colorcode 2 are blue ect...
I haved tested with
Me!colorcode.forcolor = (rgb,255,0,0) bud it doest'n work.

I tray to find a solution based on programming code with vba. thanks anyway

Eddy,
For starters, it should read Me!colorcode.Forecolor = rgb(255,0,0).
Second, changing properties in a row of a datasheet or continous form
will affect all rows, not individually.

Feb 19 '07 #2

P: n/a
Conditional formating set for each field on the form will allow you to
set the background could for 3 of the conditions.

And that will work on all form types including datasheet view.

Try that

Ron

Feb 19 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.