Organizer Advantage is powerful yet easy to use database manager for Windows.
Advantage Designer lets you modify our solutions or easily create new ones.
Take control of your data with our simple or buinsess database software solutions.


 |  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 


easy-to-use database designer

Text / Mask Edit

Mask Edit allows you to set a mask for Simple Text fields.

If you want to use a Text/Mask field in your table:

  • Create Text field type
  • Select Mask Edit in the Select Control Type window

You can use this function in the following situations:

  • USA, Social Security Number mask 000\-00\-0000
  • Phone mask \(999\)AAA\-AAAA will allow entries: (___)232-23232, (604)OUR-NUMB
  • Invoice number mask >LL000\-0000 will allow entries: AC989-2344, BC090-2343
  • Canadian Social Insurance Number mask 000\ 000\ 000 will allow entries: 234 123 232, 848 848 848 (note: the mask does not validate the number)
  • ISBN number mask 0\-00\-000000\-0 will allow entries: 2-33-343434-9, 9-23-323298-8 (note: the mask does not validate the ISBN number)

If a ">" character appears in the mask, all characters that follow are in uppercase until the end of the mask or until a < character is encountered.

If a "<" character appears in the mask, all characters that follow are in lowercase until the end of the mask or until a > character is encountered.

If these two "<>" characters appear together in a mask, no case checking is done and the data is formatted with the case the user uses to enter the data.

The character that follows a "\" character is a literal character. Use this character to use any of the mask special characters as a literal in the data.

The "L" character requires an alphabetic character only in this position. For the US, this is A-Z, a-z.

The "l" character permits only an alphabetic character in this position, but doesn't require it.

The "A" character requires an alphanumeric character only in this position. For the US, this is A-Z, a-z, 0-9.

The "a" character permits an alphanumeric character in this position, but doesn't require it.

The "C" character requires an arbitrary character in this position.

The "c" character permits an arbitrary character in this position, but doesn't require it.

The "0" character requires a numeric character only in this position.

The "9" character permits a numeric character in this position, but doesn't require it.

The "#" character permits a numeric character or a plus or minus sign in this position, but doesn't require it.

The ":" character is used to separate hours, minutes, and seconds in times. If the character that separates hours, minutes, and seconds is different in the regional settings of the Control Panel utility on your computer system, that character is used instead.

The "/" character is used to separate months, days, and years in dates. If the character that separates months, days, and years is different in the regional settings of the Control Panel utility on your computer system, that character is used instead.

The "_" character automatically inserts spaces into the text. When the user enters characters in the field, the cursor skips the _ character.

text field type, edit mask control type, mask display
text field type, edit mask control type, data display

 

Copyright © 2021 · All Rights Reserved · PrimaSoft PC