Re: auto check a checkbox based on criteria

Tech-Archive recommends: Fix windows errors by optimizing your registry

Could you be less vague? Do you want to display a check box as "checked"
based on a value or values in other fields?
You can set the control source of a check box to any expression that
evaluates to true or false. For instance:
=[Gender]="F"

Duane Hookom
MS Access MVP

"Kitty" <Kitty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EC322787-9C26-4B28-BB13-83E8E41F37C9@xxxxxxxxxxxxxxxx
How do I auto check a checkbox in an Access report based on a criteria?


.

Relevant Pages

  • Re: Timetable
    ... FieldName3 Datatype (display this one on time line) ... MS Access MVP ... I've been looking at your ship rotation report, and I've taken it apart to ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: Subreport vs queryquestion
    ... Duane Hookom ... MS Access MVP ... What section of the report are the controls in? ... It is not the inability to display more than 255 characters. ...
    (microsoft.public.access.reports)
  • Re: Query "Expression Problem"
    ... >>This should display all records with a Deadline Date ... >>Duane Hookom ... >>MS Access MVP ...
    (microsoft.public.access.queries)
  • Re: display certain information
    ... but if none don't display any of the numbers... ... >> Duane Hookom ... >> MS Access MVP ... >>> so if an employees house and cell numbers are in the database but the ...
    (microsoft.public.access.queries)
  • Re: Two table query not allowing entry.
    ... MS Access MVP ... orders with a check in the yes/no box and display the complete order. ... "Duane Hookom" wrote: ... Ordertype, DFlag, OrderDate. ...
    (microsoft.public.access.queries)