Results 1 to 3 of 3
  1. #1
    Nokia N93 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    55

    question about hidden fields and checkboxes


    is it possible when checking a check box , another 3 text boxes appear in the same window with one of them having the the current date and time ?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Of course. Use the AfterUpdate event of the CheckBox to make the TextBoxes visible.

  3. #3
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    I have three text boxes Text15, 17 and 19 one check box Check21. set the Visible property of all the text boxes to No. the put this code in the after update event of the Check box:

    Me.Text15.Visible = True
    Me.Text17.Visible = True
    Me.Text19.Visible = True
    Me.Text19 = Date


    This will make the text box visible when the check box is checked.

    if u want the text boxes to become invisible when the Check box is Checked of then

    If Me.Check21 = True Then
    Me.Text15.Visible = True
    Me.Text17.Visible = True
    Me.Text19.Visible = True
    Me.Text19 = Date
    Else
    Me.Text15.Visible = False
    Me.Text17.Visible = False
    Me.Text19.Visible = False
    Me.Text19=Null
    End If

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

Similar Threads

  1. Column Order, Hidden, Name
    By Eightball3 in forum Forms
    Replies: 1
    Last Post: 06-30-2010, 12:35 PM
  2. Hidden Attributes
    By NMJones in forum Access
    Replies: 1
    Last Post: 02-09-2010, 10:57 AM
  3. Simple question about checkboxes
    By George_E in forum Access
    Replies: 9
    Last Post: 12-08-2009, 01:00 AM
  4. subform controls hidden
    By bkelly in forum Forms
    Replies: 0
    Last Post: 09-26-2009, 10:12 AM
  5. Unhide Hidden Query
    By Valeda in forum Queries
    Replies: 2
    Last Post: 05-12-2006, 05:58 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