Results 1 to 2 of 2
  1. #1
    DCV0204 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    85

    SQL in Unbound Text box on Form

    Hello, I know that this is probably simple but I have tried everything I can think of.
    I have an unbound text box where the font style is "Arial"; however I would like a part


    of the information to be font style "Script".

    Here is what I have (but doesn't work):
    "If you have questions or any of the above information is incorrect, regarding your participation, please contact staff at 1-800-852-XXXX or email at Provider.Email@tn.gov.
    Sincerely,

    " &<fontstyle= script>& [Signature]</fontstyle>

    Thanks,
    Lisa

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    well its not sql...but it is vba..... but in any case the .accdb file type did introduce rich text features into Access which does allow different color, font etc. But honestly I've never seen this question and I don't know to what degree it can be manipulated within a single text box and dynamically with code. Certainly if you used 2 separate controls you could have one in font A and the other in font B - though that may not work for you.

    sorry not to be more helpful but if you specifically research Rich Text features in your version of Access you should get the info on what can be done with this ability.

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

Similar Threads

  1. Replies: 1
    Last Post: 11-05-2012, 11:26 PM
  2. Display record in unbound text field on form
    By MAABDOLAT in forum Forms
    Replies: 1
    Last Post: 07-25-2012, 06:10 PM
  3. Replies: 2
    Last Post: 06-11-2012, 09:37 AM
  4. Transfer Text to Unbound Form
    By DWS in forum Forms
    Replies: 3
    Last Post: 08-25-2009, 08:04 AM
  5. Unbound text box truncating text
    By gddrew in forum Forms
    Replies: 0
    Last Post: 03-02-2006, 11:26 AM

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