[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 751
  • Last Modified:

How do I set the “Field Size” for a 6 digit number in a Field on a Table?

In my table, I have a WKOrderNum field and the End User inserts a 6 digit number in the form.  Initially, I had the Field in the Table setup as a “Data Type” Text and the “Field Size” 6, but I needed to change the “Data Type” to a  Number  because of the Reports that I created required Sorting in  numerical order. For example if, the WKOrderNum field was “3456727”, “3572”, and “3456728”,  the results were “3456727”, “3456728” and “3572”.  Therefore, I change the WKOrderNum field to a “Number” Data Type and the “Field Size” as an Integer” .  This resulted with too many digits.   Problem: How do I set the “Field Size” for a 6 digit number?  
I am a novice, so please give me details :~)
0
janandben
Asked:
janandben
1 Solution
 
TonyRebaCommented:


1.Right-click the table that contains the field that you want to change, and then click Design View.

2.In the table design grid, select the field for which you want to change the field size.

3.In the Field Properties pane, on the General tab, enter the new field size in the Field Size property. You can enter a value from 1 to 255. This number specifies the maximum number of characters that each value can have. For larger text fields, use the Memo data type.

 Note   For data in a Text field, Access does not reserve space beyond what is necessary to hold actual values. The Field Size property is the maximum field value size.

http://office.microsoft.com/en-us/access-help/set-the-field-size-HA010274716.aspx
0
 
Brian GeeCommented:
Make the field a Text Data Type.

The Field Size should be 6.

The Input Mask should be ######.
0
 
MINDSUPERBCommented:
You may use the Validation Rule combined with Validation Text of the Table Property.

Type <999999 in the Validation Rule Row of the General Property Tab and "This field only holds 6 digits" in Validation Text.

Sincerely,
Ed
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
MINDSUPERBCommented:
The screenshot below will surely help you figure it out.

Ed
Validation-Rule.jpg
0
 
Rey Obrero (Capricorn1)Commented:
validation rule should be

validation rule    <1000000
0
 
Nick67Commented:
The reports have a sorting and grouping dialog.
In the query driving the report, you could have created a calculated field
MySortOrder:CLng(WKOrderNum)
And then sorted the report by it.

Then you wouldn't need to change your table
query.jpg
sort.jpg
0
 
GRayLCommented:
I believe Yobri had it right at http:#a35462268
0
 
MINDSUPERBCommented:
@Cap

I agree to include the 999999.

Thanks Cap.

Ed
0
 
janandbenAuthor Commented:
Thanks Yobri.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now