Please help with @ "at sign" in a formula

[Guest]

I am reworking/learning a DB & found a fomula for a text box under
properties/format, like so...

;@;"None"

What this is doing is that if the field in the table that this text box
represents is empty, it fills in a "None". It also works like this...

@;"None"

What I need to know & can't find anywhere on & off line is what the actual
funtion the @ performs or references to it or how it can be used. Does anyone
know?

 

[Wayne Morgan]

From the help file:

"For example, if you have a text box control in which you want the word
"None" to appear when there is no string in the field, you could type the
custom format @;"None" as the control's Format property setting. The @
symbol causes the text from the field to be displayed; the second section
causes the word "None" to appear when there is a zero-length string or Null
value in the field."

There are two sections in the Format statement, the first section formats
the field if it has text, the second formats the field if it is a
zero-length string or Null.

The help article title is "Format Property - Text and Memo Data Types".

 

[Guest]

Thanks for the extremely fast reply!
Thats what I needed to find out. It's incredible how difficult it is to find
anything in the help files. I'd have sworn it wasn't in there. I searched
every variation of this in the help files & came up empty(or missed it
completely).
Thanks again.