PDA

Click to See Complete Forum and Search --> : Using If statements to change font size, access Reports


DarrenBaker
May 15th, 2009, 10:48 AM
I'm trying to change the font size so as its larger given the data is the given criteria, within a report in Access.
I've tried putting this code into the VB code for the report

Private Sub ChangeFontSize()
If TicketType = "C" Then
TicketType.Font.Size = 48
Else
TicketType.Font.Size = 20

End If
End Sub

Be grateful of any help? Thanks

Encoder
May 19th, 2009, 01:46 AM
Is the report a Data Report or Crystal Report? and what component is the TicketType? (i.e. textbox, label)? And what happens when you put that code?