The symbol in the first section causes the text from the field to be displayed and the second section causes the word "None" to appear when there is a zero-length string or Null value in the field. Each section contains the format specification for different data in a field.įormat for fields with zero-length strings and Null values.įor example, if you have a text boxcontrol in which you want the word "None" to appear when there is no string in the field, you could type the custom format as the control's Format property setting. For example, if you use a form to collect credit card numbers, and you store those numbers without spaces, you can use a custom format to add the appropriate spaces to make the credit card numbers easier to read.Ĭustom formats for Text fields can have up to two sections. Typically, you apply custom formats to Short Text and Long Text data types to make the table data easier to read. If you don't specify a format, Access left aligns all text in datasheets. The Long Text data type has both custom and Rich Text formatting.
The Short Text data type has only custom formats. The Short Text and Long Text (also called Memo) data types do not have predefined formats. Formatting only changes how the data is displayed and does not affect how the data is stored or how users enter data. When you apply a format to a table field, that same format is automatically applied to any form or report control that you subsequently bind to that table field. With text formatting you have two choices: keep the default formats or create a custom format. Short Text and Long Text fields (also called Memo) are perhaps the most commonly used Data Types.
0 kommentar(er)
