Table Field: Format Property

Symbol Description
@ Text character or a space is required
& Text character is not required.
< Force all characters to lowercase.
> Force all characters to uppercase.

Format Property

takes data entered like:

and displays it as:
@@@-@@-@@@@ 345678901 345-67-8901
Shows with the hyphens but is not stored with them.
@@@@@@@@@ 345-67-8901
345678901		 345-67-8901
345678901
Text shown just as typed
> carpenter
CARPENTER
Carpenter		 CARPENTER
CARPENTER
CARPENTER
Forces all characters to upper case
< carpenter
CARPENTER
Carpenter		 carpenter
carpenter
carpenter
Forces all characters to lower case
@;"Unknown"
 		 Null value Unknown
Zero-length string Unknown
Any text Shows the word Unknown if there are no characters entered. Otherwise the text is shown just as it was entered.

Lessons Databases Appendix

Teachers: Request permission to use this site with your class
 
Copyright © 1997-2012 Jan Smith   <jegs1@jegsworks.com>
All Rights Reserved

Icon: DonwloadIcon: CDWant a local copy with no ads? - Download/CD

Want to help?

~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God.  ~~

Last updated: 30 Apr 2012