Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2009
    Posts
    20

    Unanswered: Can I make one particular text item bold throughout my DB??

    I have a database building specs for our development guys they pick chunks of text using forms and they compile in a report. However I have hit a snag, to conform with Company policy I need to input ® in superscript after each product in the reports. It is only that one thing that needs superscripting and it is the same every time, is there anything I can do?
    Last edited by radder; 11-23-09 at 11:43.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    You're really not very clear as to exactly how you're doing this, but in general it would be something like

    Me.ProductName = Me.ProductName & Chr(174)

    BTW, what does your thread title have to do with the question posted?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Nov 2009
    Posts
    20
    Sorry I posted the subject then someone changed their mind thanks for the response.

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Don't you hate when that happens?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Nov 2009
    Posts
    20
    I can get the character to appear however the chunks of text are stored in a table. Is there anyway to store the superscript in there or make that character default to superscript throughout the DB?

  6. #6
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    If the ProductName field is bound to the table, the Registered mark will be saved as well, using the code I gave you.

    ProductName will appear in the table as

    ProductName ®
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  7. #7
    Join Date
    Nov 2009
    Posts
    20
    Thats half solved it now the issue is where the product name appears randomly mid paragraph.

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so then you may have to run a vba procedure to do that for you, unless the replace fucntion work inside a query
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    As stated previously, you're really not very clear as to exactly what you're doing here, or how these "chunks of text" are being selected and inserted. Obviously, Access has to be told what text to place the symbol after. More details are needed.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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