Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2006
    Location
    Melbourne, Victoria, Australia
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    quotation marks around text (2003 )

    Hi all, I would like the text in a text box to appear with quotes around it (ie. "mikey"). the code for control source in the text box that i'm using is: =Chr(34) & [ImgText] & Chr(34). I just get #Error from this. What am i doing wrong? thanks muchly, Van

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: quotation marks around text (2003 )

    Access 2003 (in particular) gets confused when the control on the form has the same name as field.

    Change the Name on the control to txtImgText (on the 'Other' page of the Properties box) and your code should work.
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Oct 2006
    Location
    Melbourne, Victoria, Australia
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: quotation marks around text (2003 )

    thanks muchly John, that worked a treat. Van

Posting Permissions

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