help about change fonts in reports so the same field in diffrent record could have diffrent font

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • krikaran adel
    #1

    help about change fonts in reports so the same field in diffrent record could have diffrent font


    Hi,

    First of all I found your tips very usfull, of course these tips becuas
    of all years working in access. really greet site.

    my Quation:

    is this away to change fonts in reports so the same field in diffrent
    record could have diffrent font.

    lets see I have table contain feild like stName and make a report based
    on it and I want to change stName font in second record differs from
    stName font in first record.

    I try but the changes of font take effect to all records.

    thaks for your help



    khorshid




    *** Sent via Developersdex http://www.developersdex.com ***
    Tags: None
    • Allen Browne
      #2
      Re: help about change fonts in reports so the same field in diffrent record could have diffrent font

      Use the Format event procedure of the section where the text box resides.

      This is the basic idea:

      Private Sub Detail_Format(. ..
      Me.[SomeField].FontName = Me.[SomeOtherField]
      End Sub

      It certainly needs more than that to cope with cases where the other field
      is null, or contains a name that is invalid or there is no such font on the
      machine.

      --
      Allen Browne - Microsoft MVP. Perth, Western Australia
      Tips for Access users - http://allenbrowne.com/tips.html
      Reply to group, rather than allenbrowne at mvps dot org.

      "krikaran adel" <krikaran@yahoo .comwrote in message
      news:1213794774 _10609@news.new sfeeds.com...
      >
      First of all I found your tips very usfull, of course these tips becuas
      of all years working in access. really greet site.
      >
      my Quation:
      >
      is this away to change fonts in reports so the same field in diffrent
      record could have diffrent font.
      >
      lets see I have table contain feild like stName and make a report based
      on it and I want to change stName font in second record differs from
      stName font in first record.
      >
      I try but the changes of font take effect to all records.
      >
      thaks for your help
      >
      >
      >
      khorshid
      >
      >
      >
      >
      *** Sent via Developersdex http://www.developersdex.com ***

        Comment

        Previous template Next
        Working...