Hi.

I have an Access problem:

I have a continuous form which details of people. One of the fields states whether a person has filled in a form or not. I would like an image to appear if the form is filled, and a different image to appear if the form isnt filled.

The field is a text box and has a few different options.

Is this possible?

Thank You.

This is possible, but problematic on a continuous form.

What I would try is adding both images to the continuous form's detail section, and then setting both of them to Visible = No.

Then on the form's Detail section On Format event, you could do this:

If Me.MyTextBox = "Some Value" Then
   Image1.Visible = True
   Image2.Visible = False
Else
   Image1.Visible = False
   Image2.Visible = True
End If

   The problem with continuous forms is that it will decide which value it should use from the first record, and apply it to all the records on the form. So this may not work. Conditional formatting on a continuous form is difficult.

Is this what you tried?

mmcdonal

ye, it applies it to all records. cond. formatting doesn't work with images unless anyone has any ideas

It is doable, but problematic. You would have to do a query and match up the condition field to a table in which you store the images, and then base the continuous form on the images. Not fun.

mmcdonal

Sorry, base the continuous form on the query.

mmcdonal

sounds promising, how do you store images in tables?

ok, sorted that bit. BUT

how do i get the image to appear on the form. at the moment i have to double click on the box and then the image opens in MS Picture Manager. I would like the pic to be present on the form.

thanks

Sorry for the delay. I am swamped at work and school. Take a look at the Northwind database. Open the EMployee form, and you can figure it out pretty easily from there. Does that help?

mmcdonal

All sorted, thank you very much for your time and help.

The OnFormat event does not apply to forms, only reports, so how could this possibly work?