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]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.