display green dots insted of value "1" in form? help.

[selvsagt]

I would like the form to show a green dot, or equivalent, if the value is anything else than blank.

the form is based on a crossquery that shows a lot of fields in columsn that has value 1, or blank. (it's always 1 or blank)

It is about 15 colums with "skills" and the employees are sortered in rows.

se example in BMP.

Insted of the number "1", i would like a green dot.
Does anyone know how to do this?

 

[ColinEssex]

You may be able to use 'BackColor' to make the cell green.

I may be totally wrong here, I've never done it in a crosstab. Check it out maybe?

Col

 

[JP-C]

If you rightclick your form field and check the element source, there should be an icon "..." where you can build the expression that will be the datasource for the element.

You can have something like
IIf (myfield="1";".";"")

I think you'll be able to get your dots like that but not your formatting.

Alternatively you could write some code for the beforeupdate event that does the same thing and includes your formatting.

I don't have much time to try it atm, but this might give you some ideas.

 

[Dennisk]

if you are using access 2000 or above you may find conditional formating a help.