Formatting different records in form

H

Hour

I have built a form that value is bound to a table, I want to format any record that have the value is greater than 100 with Fore Color is Red in the Current Record event, but when my cursor position in current record is Red all the records. Any one has idea? help me.
 
K

Ken Snell

The format of a control in a continuous forms view is the same for all
instances of that control.

Try using Conditional Formatting instead. That allows you to have
individualized formatting for each record.

--
Ken Snell
<MS ACCESS MVP>

Hour said:
I have built a form that value is bound to a table, I want to format any
Click to expand...
record that have the value is greater than 100 with Fore Color is Red in the
Current Record event, but when my cursor position in current record is Red
all the records. Any one has idea? help me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
color coding values 0
Lookup current record with ComboBox, any changes create new record 3
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Excel does not accept text format! 0
How do I clear a form? 0
QBF & Query Malfunction 0
Populate main form from subform record 0

Top