Results 1 to 2 of 2

Thread: Using If statements to change font size, access Reports

  1. May 15th, 2009, 10:48 AM #1
    DarrenBaker
    DarrenBaker is offline

    Thread Starter
    New Member
    Join Date
    May 2009
    Posts
    1

    Using If statements to change font size, access Reports

    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
    Reply With Quote Reply With Quote
  2. May 19th, 2009, 01:46 AM #2
    Encoder
    Encoder is offline
    Lively Member
    Join Date
    Dec 2008
    Posts
    108

    Re: Using If statements to change font size, access Reports

    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?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width