How to use a dash in format Property of a control (1 Viewer)

[darbid]

I would like to show "YES" if a control is not null or a "-" if it is empty or null.

From what I understand of the Format property this should be

"Yes";"-"

But Access removes the quotes from the second part.

So how can I use a "-" in the property?

Thanks guys in advance.

 

[Galaxiom]

The pattern is :
Postitive;Negative;Zero;Null

Maybe this:
"Yes";"Yes";"-";"-"

 

[darbid]

Hi and thanks for responding.

Actually my control source is a Date - from what I can tell so far it is acting similar to the instructions in the help files as if it was a text source.

Thus the Format differentiates between (null or nil string) and if there is something.

I think it is working?

 

[darbid]

scratch that I am wrong - you are right.

I was dreaming.

 

[Galaxiom]

The Format property is a curious beast with many different manifestations.

BTW. If you want to show the value in one of the positions of the +;-;0;Null form then use the ampersand. You can also use colours by placing the colourname in square brackets after the format information. eg:
&;&[red];"Nil";"N/A"

It will take literals if you place a backslash before them in a numerical format string.

Dates also work in the format property. Any of the letters y,m,d,h,n,s will format as date parts while others will be taken as literals (a backslash inserted before them).

Standard formats will be changed to their format name.

Just don't try to put a percent sign in there.

 

[darbid]

The Format property is a curious beast with many different manifestations.

BTW. If you want to show the value in one of the positions of the +;-;0;Null form then use the ampersand. You can also use colours by placing the colourname in square brackets after the format information. eg:
&;&[red];"Nil";"N/A"

It will take literals if you place a backslash before them in a numerical format string.

Dates also work in the format property. Any of the letters y,m,d,h,n,s will format as date parts while others will be taken as literals (a backslash inserted before them).

Standard formats will be changed to their format name.

Just don't try to put a percent sign in there.

Thanks again. The colours i might just use.