[AccessD] Access Field Format

Stuart McLachlan stuart at lexacorp.com.pg
Fri Jan 25 17:24:27 CST 2013


If it's by itself for a text field, it is pointless. It's only useful in a text formating expression when 
you have multiple formats:

 "if you have a  textbox 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."

-- 
Stuart

On 25 Jan 2013 at 16:34, Arthur Fuller wrote:

> In an Access db that I inherited, a bunch of fields (almost all of them)
> have been assigned a format of "@". I have never seen this before and have
> no inkling what it means.
> 
> Do you know?
> 
> TIA,
> Arthur
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list