Modify fields programmatically

  • Thread starter Thread starter Jennifer Beck
  • Start date Start date
J

Jennifer Beck

It is possible to color code certain fields in a report in
Visual FoxPro. Is it possible to do this in Access 97?
How?
 
Jennifer said:
It is possible to color code certain fields in a report in
Visual FoxPro. Is it possible to do this in Access 97?
How?
Click to expand...

Well, that depends on what you mean by "color code".

You can just set a control's Fore, Bac or Border Color
properties to make it always appear in the specified color.

If you want a control to be in different colors depending on
its value, then you might be able to use Conditional
Formatting (Format menu). In general, the most versatile
approach is to use VBA code in the control's section Format
event procedure.
 
You can use code in the On Format event of section containing the controls.

If Me.txtGender = "F" Then
Me.txtFirstName = vbRed
Me.txtLastName = vbRed
Else
Me.txtFirstName = vbBlue
Me.txtLastName = vbBlue
End If
 
You must log in or register to reply here.

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

Run select query from VBA code where criteria comes from a multi select ListBox 2
generating a report based on fields 1
Report linked to Foxpro Table 1
Write Name of Report Query in Report Footer 2
Highlight between 3 fields 4
Programmatically change Sort/Group field? 3
Access How to record date/time when specific field is modified in Access 2007 0
field color in report 2

Back
Top