Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    24

    Lightbulb Unanswered: Make column Invisble-Report-Access 2003

    Hi,
    I have a yes/no setting in the tables for the preferred column. I have a Query1 to get the data.
    The Report derives data from the query1. Presently the report displays the checkbox irrespective of whether the value is true or false. How to ensure that the check box is displayed only if the column value is True/Yes else it is not displayed.
    I've attached the sample db for immediate reference.
    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    place some code in the controls on format event

    if mycheckboxcontrol.checked=true then
    mycheckboxcontrol.visible=true
    else
    mycheckboxcontrol.visible = false
    endif

    this can be shortened to

    mycheckboxcontrol.visible = mycheckboxcontrol.value
    or
    mycheckboxcontrol.visible = mycheckboxcontrol.checked

    im not to sure of the precise syntax, and to be hoinest I can't be bothered to open an instance of Access to check.. but the above code may not work, but it should get you close to where you want to be
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2003
    Posts
    24

    Talking

    following your suggestion I used this..
    Code:
    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
        Me.preferred.Visible = Me.preferred
    End Sub
    It works
    Thankyou very much.
    Is there someway of rating your help.

Posting Permissions

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