how to make text bold

[JasnaP]

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

 

[nberryman]

Select the field in design view and click Format, Conditional Formatting and try that out



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[JasnaP]

Thanks Neil, I will give it a try.

Best regards
Jasna

 

[Aubs010]

The way I got it to Bold certain text depending on the value in one of the fields is:
[tt]

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If Price = "promotional" Then
        Me.FontBold = True
        Me.CurrentX = 200
        Me.CurrentY = 500
        Me.Print (Price)
        Me.CurrentX = 800 - 0
        Me.CurrentY = 500 - 0
        Me.Print (Product Name)
    End If
End Sub

[/tt]
Put that into the code for the report.

If you don't know where ot put it, ask

Aubs

 

[joebloeonthego]

I just tried this and it throws an error.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If Me.MATpercent < 0.4 Then
        Me.MATpercent.FontBold = True
    End If
End Sub

I tried it without the Me, like in your example, and I tried with .value after and I just can't get it to work.
any help would be most appreciated.
it's access 97.
thanx.

 

[hymn]

try
If Me.MATpercent < 0.4 Then
Me.MATpercent.Fontweight = bold

Hope this helps
Hymn

 

[hymn]

sorry, should of been
If Me.MATpercent < 0.4 Then
Me.MATpercent.Fontweight = 700

Hope this helps
Hymn