Hello , i would like to know if i can convert a field into a bar( black rectangle) when it gets some typed on it.

example:

field1 = " empty field" ---- no black rectangle

field1 = " whatever data on it" -------- shows black rectangle

thank you very much

M

Hi.

What I do is in every one of my tables I have a single field called "_dummy_field" and I placed that field where I want my bar - such as over the top of the field whose contents you are checking (eg "ClientName"). This field has no fill color or outline, but then I apply conditional formatting to it so that If Not IsEmpty(ClientName) then fill color is Black.

Works well.

Does that make sense?

Cheers,

Greg

You can't convert a field to another object, but you change the field's appearance based on its data, or in this case, the presence/absence of data.

Try conditional formatting, like: Add, Formula is: If [ not isEmpty ( Self ) ], and experiment a bit with the available options, especially Fill Color.

Our replies overlapped …

What I do is in every one of my tables I have a single field called "_dummy_field" and I placed that field where I want my bar

I was also thinking of a dummy field, if one really needs a “black bar”; now I realize that it's easier (and doesn't require dummy fields that clutter your schema) to just place the same field on the layout a second time and format that one conditionally, e.g. make it a rectangle with black fill and black text.

Hello , i would like to know if i can convert a field into a bar( black rectangle) when it gets some typed on it.

For what purpose?