access 2007 vba report checkbox

[attrib75]

Hello,

I'm trying to make a checkbox checked on a report depending on the existance
of a file in a directory. Its in the report_current event. So far no luck.
Not sure I have the syntax right.

me.checkboxname = true

I took out the condition to see if the file existed, just to test if I could
even set the checkbox to checked. Doesn't work. Could it be

me!checkboxname = true

or

me.checkboxname = -1?

 

[Jeff Boyce]

What happens when you tried those?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Beetle]

Reports are static representations of data. You can't directly modify
data on a report, you have to change the data in the underlying
table or query.

Also, reports do not have a Current event. Did you mean to say that
you are working with a form?

 

[attrib75]

Thanks,

No I'm trying to do it in a report. I was getting the feeling you couldn't
modify anything in a report. Trouble is I don't know how in the report, to
check a file system for the existance of a .jpg. If its there, check the
box. I was trying to do:

if \\filepath\name.jpg = name.jpg then

me.checkbox.value = true

in vba on the current_record event but you cant modify reports that way I
guess. How do you get a current list of files in a folder into a table so
that the report can check it?

 

[attrib75]

Nothing changes, and the report populates as usual.