A
AuditIA
The field is Text. Should I remove the @ sign, or leave it? What does it
mean, anyway?
mean, anyway?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jerry Whittle
It means that a text character (either a character or a space) is required.
If you want that to be true, leave it. If it doesn't matter, you can remove
the @ sign.
If you want that to be true, leave it. If it doesn't matter, you can remove
the @ sign.
K
Ken Sheridan
The @ formatting character means that a text character (either a
character or a space) is required. It can be followed by a default,
e.g. a Format property of:
@;"Empty"
would show the contents of the field or 'Empty' if there is no
content, i.e. its Null or a zero-length string. NB: this does not
mean the value of the field is the string 'Empty', it just appears as
such.
Whether you should remove it or not depends on what you require. If
its just a single @ sign then it doesn't really serve any purpose and
could probably be removed; normally you'd have several in combination
with other formatting characters to establish a format pattern.
Ken Sheridan
Stafford, England
character or a space) is required. It can be followed by a default,
e.g. a Format property of:
@;"Empty"
would show the contents of the field or 'Empty' if there is no
content, i.e. its Null or a zero-length string. NB: this does not
mean the value of the field is the string 'Empty', it just appears as
such.
Whether you should remove it or not depends on what you require. If
its just a single @ sign then it doesn't really serve any purpose and
could probably be removed; normally you'd have several in combination
with other formatting characters to establish a format pattern.
Ken Sheridan
Stafford, England
A
AL-MURISI
AuditIA said:The field is Text. Should I remove the @ sign, or leave it? What does it
mean, anyway?
A
AL-MURISI
AuditIA said:The field is Text. Should I remove the @ sign, or leave it? What does it
mean, anyway?
A
AuditIA
Thanks everyone. I should have known that. I'm still not as familiar with
2007 as I was with 2000 and when I'm under time restraints, I sometimes
overlook the obvious and assume it's something new. The field was imported
as text from Excel 2007 and it makes sense that an @ sign in the format
property might be assumed.
Wow, what a valuable thing this group is - what a hair saver. Thanks again.
2007 as I was with 2000 and when I'm under time restraints, I sometimes
overlook the obvious and assume it's something new. The field was imported
as text from Excel 2007 and it makes sense that an @ sign in the format
property might be assumed.
Wow, what a valuable thing this group is - what a hair saver. Thanks again.