Solved @ Symbol in Field properties (1 Viewer)

[cgala]

Hi all,

I've inherited a database and many of the fields have an "@" in Field Properties > Format box.

In one case, the @ symbol was causing the Long Text to be truncated, but I haven't found any other issues with the @ symbol being present.

Does anyone know if the @ serves any particular purpose and if there would be any issues just deleting them all?

I'm using Access 2013.

 

[arnelgp]

it means the Datatype is Variant.

 

[cgala]

it means the Datatype is Variant.

Thanks! Just looked it up. However, I'm unsure why this would be added, when the DataType is already set as e.g. Short Text in the Data Type field (when in Design mode). Any idea?

 

[Galaxiom]

it means the Datatype is Variant.

No it doesn't mean that.

In a text field it means display the characters. It is normally used with another part of the Format to change what is displayed for Null or ZLS. An @ by itself would be redundant. I didn't know that it cause the string to be truncated but I am not surprised.

Text and Memo data types (Format property)

Office VBA reference topic

docs.microsoft.com

 

[cgala]

No it doesn't mean that.

In a text field it means display the characters. It is normally used with another part of the Format to change what is displayed for Null or ZLS. An @ by itself would be redundant. I didn't know that it cause the string to be truncated but I am not surprised.

Cheers! That's Useful to know how it can control the display of Null values. I think I can safely remove the symbols from the rest of the fields.