Results 1 to 7 of 7
  1. #1
    VICTOR HUGO is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Nov 2009
    Location
    Portugal - Asseiceira
    Posts
    20

    Post Format a text box Access report

    Hello,



    I would like some help how I can format the following text box in access report:

    ="Please debit our account No." & [Acnumber] & " for the amount of USD: " & [SumofCom] & ", as per attached list."

    The field [Acnumber] in boldface and [SumofCom] standard with 2 decimal places.

    Thanks in advance,

    Kind regards,
    Victor Hugo

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Set the Text Format of a textbox to Rich Text, then use HTML code within:

    ="test bold coming <b> " & [FieldName] & "</b> more text"
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    VICTOR HUGO is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Nov 2009
    Location
    Portugal - Asseiceira
    Posts
    20
    Dear Paul,

    Sorry I don't understand how to use HTML in access.
    Can you explain in detail with a text box:

    ="Please debit our account No." & [Acnumber] & " for the amount of USD: " & [SumofCom] & ", as per attached list."

    Kind regards,
    Victor Hugo

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I did, with generic text. <b> starts the bold, </b> ends it. Substitute your text and field names.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    VICTOR HUGO is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Nov 2009
    Location
    Portugal - Asseiceira
    Posts
    20
    DEar Paul,

    The result of this is like:

    test bold coming <b> 9001183637</b> more text.

    Maybe the sintaxe is not correct!

    Please help.

    Regards,
    Victor Hugo

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    As Paul shows, the HTML tags must be within quote marks. Expression in ControlSource would be like:

    ="Please debit our account No. <b><font color=red>" & [Acnumber] & "</font></b> for the amount of USD: <b><font color=red>" & [SumofCom] & "</font></b>, as per attached list."

    Make sure the control FontWeight property is set to Normal. Did you set the TextFormat property to RichText?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    VICTOR HUGO is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Nov 2009
    Location
    Portugal - Asseiceira
    Posts
    20
    Dear friend,

    Very good help and thank you so much.

    Works perfectly.

    Kind regards,
    Victor Hugo

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Rich Text Format in Access Field to Report
    By willowdom in forum Access
    Replies: 18
    Last Post: 09-10-2018, 12:40 PM
  2. Replies: 0
    Last Post: 10-06-2017, 06:22 PM
  3. Replies: 3
    Last Post: 12-30-2016, 10:27 AM
  4. Access Report to Excel format
    By mar_t in forum Access
    Replies: 3
    Last Post: 04-11-2011, 12:27 PM
  5. How to format text in a report
    By Kimelco in forum Access
    Replies: 1
    Last Post: 01-06-2006, 07:30 PM

Tags for this 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
  •  
Other Forums: Microsoft Office Forums