Results 1 to 3 of 3
  1. #1
    CementCarver's Avatar
    CementCarver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Location
    Canada
    Posts
    231

    Control Values

    Still building my audit table functionality, but one line of code I borrowed was to test the existing value of a control, using Access 2010

    ctl.value causes an error.



    but after you input the period after the variable name ctl you get the options of that control object. But there is no listing for the value, or at least I do not know the equivalent.

    Does anyone have any documentation on this object's properties? Or the right answer?

    CementCarver

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You need to show all of your code. Labels are controls too and have no .Value property.

  3. #3
    CementCarver's Avatar
    CementCarver is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Location
    Canada
    Posts
    231
    After more research I found out that not all object in a form support the .value criteria. You need to test whether the control is a text or checkbox first, before you can apply the control.value parameters.

    CC

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

Similar Threads

  1. Replies: 10
    Last Post: 02-20-2013, 07:04 AM
  2. Use String to change form control values
    By DerekAwesome in forum Programming
    Replies: 14
    Last Post: 12-02-2012, 07:19 PM
  3. Replies: 3
    Last Post: 03-29-2012, 12:40 PM
  4. Replies: 6
    Last Post: 05-05-2011, 12:40 PM
  5. Control source and calculated values
    By meistersteff in forum Forms
    Replies: 0
    Last Post: 11-23-2007, 07:04 PM

Tags for this Thread

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