I want different things to happen on the report based on data 1

[DougP]

This is version Acc 2003
Where can I do this?
I thought you used to be able to write VBA code in the Open event or Page event in older versions of Access?
I need to set things or turn them on or off.

Any help appreciated

DougP, MCP, A+

I love this site and all you folks that helped me over the years!

 

[dhookom]

Access 2003 is not much different than previous versions of Access regarding the report events. What problems are you having?

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]

 

[DougP]

for example if the
Field "Office building" is Checked or True then show the "Number of Stories" Field and its number
If it's false then don't show it.



DougP, MCP, A+

I love this site and all you folks that helped me over the years!

 

[dhookom]

You don't need code for this. You can use a text box with a control source like:
=IIf([OfficeBuilding],"Number Of Stories: " & [NumberOfStories],Null)

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]

 

[DougP]

Waht if I wanted the make the word "Commercial" Bold is it is choosen on a form from a Combo box. Or otherwise highlight it so it stands out.

DougP, MCP, A+
Build your own R2D2
I love this site and all you folks that helped me over the years!

 

[dhookom]

Look up Conditional Formatting in Help.

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]

 

[DougP]

Conditional Formating is grayed out for a Label I guess I have to change them all to text boxes and reformat them etc.


DougP, MCP, A+
Build your own R2D2
I love this site and all you folks that helped me over the years!

 

[DougP]

Well that wasn't to painfull
Thanks for the tip
and have a star

DougP, MCP, A+
Build your own R2D2
I love this site and all you folks that helped me over the years!