how to make text bold

[Jasna]

Hello all,

does anyone know how can I make text bold in a report (based
on a table), if the field in the table meets certains criteria?

For example, I have fields "Price" and "Product name" in my table. In the field "Price" user can select between normal and promotional price. In the field "Product name" the user has to fill in the name of the product.

This is what I would like to do in my report: if selected price is promotional, I would like the value in the field "Product name" to appear in bold text.

Can anyone please help me?

Thanks in advance!
Jasna

 

[mark curtis]

Jasna,

1st you need to establish(record if a price is promotional or normal) eg store a "P" for promotional or a "N" for normal in the table and call it something like PriceID.

Ensure that field is included in the query.

Then use the OnOpen event an place something like:

If me.[PriceID]="P" Then
me.[ProductName].FontBold=True
End If

 

[Jasna]

Hello Mark,

thanks for your advice. I will give it a try.

Best regards,
Jasna

 

[Rich]

You'll have to use the OnFormat/Print events not the open

 

[Jasna]

That's exactly what I did. And it's working nicely
Thanks again.
Jasna

 

[bjackson]

if you are using access 2k or more you can also use
conditional formatting, by selecting conditional formatting
from the access toolbar