Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional formatting in reports

Status
Not open for further replies.

ZABADAK

Programmer
Feb 24, 2005
39
US
I'm building a table which will be the input to my report.
In the first column I put headings for each row of data. I'd like some of these to print in bold and some in normal weight. Is it possible to have conditional formatting on a field in my report?
 
Access 2000 and later support conditional formatting in forms and reports.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Now all I need to know is how to do it. I tried putting some code in the Detail section but could not figure out how to refer to the report fields. The auto-prompter would not display the properties for me to change the FontWeight. Or is this the wrong way to do it?
 
Select a text box and check the Format Menu for Conditional formatting.

If you want to use code, you must reference a value of a bound control.

If you have additional questions, please come back with something more specific such as control and field names as well as what properties you want to change.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top