Results 1 to 3 of 3
  1. #1
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    151

    Command to display value of a variable


    I am getting an error indicating the value of my variable is too large for the field. Please tell me the command (and syntax) to display the value to the screen before attempting to do the save. Thanks!!

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Tell us about the variable-- What datatype? What are you assigning to it?

    If in vba, you could Debug.Print myvariableName and you'll either get an error or the current value in the immediate window.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    put a stop on the line after its assigned,
    ctl-G (immediate window)
    type ? , then the variable: ?iMyVar

    or hoover the cursor over the variable after the stop,it will show the value.

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

Similar Threads

  1. Replies: 2
    Last Post: 05-14-2021, 08:39 AM
  2. Replies: 4
    Last Post: 05-18-2016, 04:50 PM
  3. Pass a VB variable to SQL command
    By accessprogramer in forum Programming
    Replies: 1
    Last Post: 03-05-2015, 08:04 AM
  4. Replies: 1
    Last Post: 07-24-2014, 08:13 AM
  5. Replies: 2
    Last Post: 08-12-2011, 01:01 PM

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