Results 1 to 5 of 5
  1. #1
    allstar45 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2012
    Posts
    35

    Text to Caption conversion possible?

    I would like to set a label to what someone has written in a text box using a macro expression, or if need be, VBA.

    I think the action "SetValue" is what I want, but I'm lost on the details past that. IE.. what to put in Item and Expression.

    Any advice would be much appretiated.



    Patrick

  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,640
    I don't use macros, but I think in Item you'd put a reference to the caption property of the label you want to set, and in expression a reference to the textbox. You should be able to use the Build feature to point to each.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    allstar45 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2012
    Posts
    35
    Alright that solved my problem. I've decided to do everything with VBA, since i'm more comfertable with it.

    Much abliged.
    (is there some way to give u a thumbs up or something?)

  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,640
    Happy to help, and your thanks are enough for me. I'd use VBA too, but you seemed to be leaning towards macros.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    allstar45 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2012
    Posts
    35
    I was going to use Macros since I figured they would be simpler. Unfortunatly that was not the case :/

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

Similar Threads

  1. Saving Change to Text Caption During Run-time
    By Janoose in forum Programming
    Replies: 5
    Last Post: 05-27-2011, 01:38 PM
  2. Replies: 6
    Last Post: 01-04-2011, 05:43 PM
  3. Using a Labels Caption Programmatically
    By ksmith in forum Programming
    Replies: 2
    Last Post: 10-12-2010, 01:10 PM
  4. Conversion of database to text format.Help!!
    By sasipulikkal in forum Import/Export Data
    Replies: 3
    Last Post: 09-28-2009, 01:38 AM
  5. What I am doing wrong? (caption of report)
    By swampdonkey in forum Reports
    Replies: 0
    Last Post: 12-07-2006, 11:07 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