What does the Field Size property do?  What is the default field value for Text fields, and why would you want to change it?  What is the default field value for Number fields, and why would you want to change it?

What will be an ideal response?


(Answers may vary)
The Field Size property sets the number of characters you can store in a Text, Number, or AutoNumber field.

For Text fields, the default value is 255 characters. This means that every field value must contain 255 or fewer characters. You can change the Field Size property for a Text field to store fewer characters. For example, if you create a field that stores state abbreviations, you might set the Field Size property to two characters, because all state abbreviations contain two characters. This change will ensure that no one can enter a three-character state abbreviation, which would be an incorrect field value.

For Number fields, the Field Size property uses a different way of expressing the length. The default Field Size property for a Number field is Long Integer, which stores very large positive and negative whole numbers. Other field sizes for Number fields store numbers with decimals (such as 101.24), positive whole numbers only, and numbers that are less than or equal to 255.  An example of changing the field size would be if you wanted to limit the space where a zip code can be entered, or if you wanted to include decimal places for entering dollar amounts.

Computer Science & Information Technology

You might also like to view...

GF stands for __________ field in honor of the mathematician who first studied finite fields. ?

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

When discussing image file types, which of the following is NOT true?

A) Information is lost every time the file is saved in JPEG format. B) JPEG files are used for images in web pages. C) TIFF files have a higher compression ratio than JPEG files do. D) JPEG and TIFF are the two main file formats used by digital cameras.

Computer Science & Information Technology

A(n) ____ is the physical computer where the virtual machine runs.

A. DNS server B. image C. guest D. host

Computer Science & Information Technology

The list of sources inserted on the last page of a research paper is the Works Cited or ________

Fill in the blank(s) with correct word

Computer Science & Information Technology