Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Strange Table (A2000 SR1)

    In one of my tables (tblStaff) I have two fields:
    [Productive] &[ Active]

    They are both set to Yes/No

    In table view, one column says Yes or No, the other shows tick box's ??

    How do I change the Yes or No column to show tick box's and will this affect my data ?

    Dave

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

    Re: Strange Table (A2000 SR1)

    Open the table in design view.
    Click in the field that displays as Yes/No
    In the lower half of the window, click the Lookup tab.
    Click in the Display Control property.
    Use the dropdown list to select the preferred display (Check box, Text box or Combo box).

  3. #3
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Strange Table (A2000 SR1)

    Thanks Hans, Sorted

    Dave

Posting Permissions

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