Use the Format property box for a field to control how the data is
Ngày đăng:
12/11/2022
Trả lời:
0
Lượt xem:
193
Show
You can format the properties for your query’s fields in Design View so that their data appears in the format you specify. For example, you can specify where Access display the thousands operator in the Number field, format date fields to display different date formats, or format a text field to only display upper case letters.
Refer to the tables below to see how you can format fields differently in Access.
FREE Quick ReferenceClick to Download Free to distribute with our compliments; we hope you will consider our paid training. What does the Format property of a field do?You can use the Format property to customize the way numbers, dates, times, and text are displayed and printed.
What happens when you click in the Input Mask property box in the field properties section and then click the Build button at the right side of the box?What happens when you click in the Input Mask property box in the Field Properties section and then click the Build button at the right side of the box? The first Input Mask Wizard dialog box opens.
How do you click the property box for the data type property?Simply click the field name to view its properties. Click the field's Data Type box. Now select the data type you want. Click the Data Type list arrow and select a data type.
How can you set the properties of a field?Access opens the table in Datasheet view. Select the field (the column) that you want to change. On the Fields tab, in the Properties group, click the arrow in the drop-down list next to Data Type, and then select a data type. Save your changes.
|