Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Continuous Form (2000)

    I have a continuous form with the following code in the on current event, however is only makes the items visible when I clikc on a field in particular record. How do I get so so that in each record if it has it nit displays it, if it doesn't have a true value it does'nt


    If PPToggle = True Then

    PPTitle.Visible = True
    PPFirstname.Visible = True
    PPLastname.Visible = True

    Else

    PPTitle.Visible = flase
    PPFirstname.Visible = False
    PPLastname.Visible = False

    End If
    End Sub
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Continuous Form (2000)

    There is actually only one set of controls in a continuous form. If you show or hide a control, it will affect all displayed records. So you cannot hide a text box in record 1 and show the same text box in record 2. You could use conditional formatting to change the formatting of controls depending on the value of PPToggle.

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Continuous Form (2000)

    how would that be achieved?
    Best Regards,

    Luke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Continuous Form (2000)

    Open the form in design view
    Select the text boxes/combo boxes whose appearance you want to change.
    Select Format | Conditional Formatting...
    Select Expression Is from the dropdown list under Condition 1.
    Enter [PPToggle]=True if you want to specify custom formatting for if PPTToggle is True, or [PPToggle]=False if you want to specify custom formatting for if PPTToggle is False.
    Click the various formatting buttons (bold, italic, underline, background colour, font colour and enabled) to specify a format. For example, you could disable controls if PPToggle is False.
    Click OK.

Posting Permissions

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