Creating a "checkbox"

[Guest]

I have a patient billing report that I am creating for an ambulance company.
I have a preprinted billing form that we use to fill in all the patient
informationby hand. This form has all the "labels" (First Name, MI, Last,
Address, SSN, DOB, etc.)

I am trying to create a report that I can take the same preprinted form and
feed into the printer and have the report enter the info instead of
handwriting it all.

My problem is this: There are fields, such as Medicare, Medicaid labels, on
the preprinted form that have a box next to it that is suppose to be checked
if the patient has Medicare and/or Medicaid. How do I create a box within
the report and have it check to see if there is a value in the Medicare or
Medicaid field so it will put a check mark in it?

Thanks,
Les

 

[Gary Walter]

"WLMPilot"wrote:

I have a patient billing report that I am creating for an ambulance
company.
I have a preprinted billing form that we use to fill in all the patient
informationby hand. This form has all the "labels" (First Name, MI, Last,
Address, SSN, DOB, etc.)

I am trying to create a report that I can take the same preprinted form
and
feed into the printer and have the report enter the info instead of
handwriting it all.

My problem is this: There are fields, such as Medicare, Medicaid labels,
on
the preprinted form that have a box next to it that is suppose to be
checked
if the patient has Medicare and/or Medicaid. How do I create a box within
the report and have it check to see if there is a value in the Medicare or
Medicaid field so it will put a check mark in it?

Hi Les,

Several alternatives come to mind...
(if I understand correctly)

1) if report based on query,
then in query create expression that evaluates
to true or false,
then, adding that query field to report will automatically
give you an "Access checkbox" ...

2) create a square textbox with source...

if [Medicare] field is type number,

=IIF([Medicare] IS NULL, " ", "X")

or, if [Medicare] is type text.

=IIF(Len(Trim([Medicare] & "")) = 0, " ", "X")

or, if you want to test both fields,

=IIF(Len(Trim([Medicare] & "")) = 0 OR Len(Trim([Medicaid] & "")) = 0, "
", "X")

I like option 2 for situations like you have....
just mess with font settings to get a checkbox
that looks like "actual form checkbox"

good luck,

gary