Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Newtown, Pennsylvania, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting within an unbound control on a report

    I have the following code in an unbound control on a report in Access 2000:
    =IIf([au]<>'',[au] & " ",'') & [ti] & ". " & [jf] & " " & [yr] & ":" & [vl] & IIf([is]<>'',"(" & [is] & ");",";") & [sp] & IIf([ep]<>'',"-" & [ep],'') & "."

    How can I make [jf] print out in italics?

    TIA

    Kiwi44

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formatting within an unbound control on a report

    If you're trying to make just one part of the expression print in italics, you can't. However, you could try using code in the OnFormat event of the section header to set the FontItalic property of the control to true or false, depending on the value.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Newtown, Pennsylvania, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting within an unbound control on a report

    Because I couldn't find anything in the help files, I figured that might be the case, unfortunately. I would like to print out a bibliographic reference list, and it would be nice if I could italicize/bold some sections of each citation.

    Oh, well, time to take the bibliography back into Reference Manager, which _can_ do the formatting[img]/w3timages/icons/mad.gif[/img].

    Thanks for the advice, though!

    Kiwi44

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formatting within an unbound control on a report

    If you're desparate to italicize only one part, you'll have to put it into a separate field and only populate it based on a formula. Then you can set the format to FontItalic for that control and it will only show up when there's a value in it.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Newtown, Pennsylvania, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting within an unbound control on a report

    I realized that the separate field was an option, but to conserve paper (the report is 168 pages as is!), I really need the concatenated field.

    I found the answer on the microsoft.public.access.reports newsgroup, in a response to a message from 'glider'. It does require some coding, but a good example is provided at http://www.lebans.com/Report.htm. This should answer all my needs when I get time to work on it.[img]/w3timages/icons/smile.gif[/img]

    Thanks for your help.

    kiwi44

Posting Permissions

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