TextBox.PostalAddress property (Access)
Use the PostalAddress property to specify or determine the postal code and the Customer Barcode data corresponding to the address information displayed in a specified field or text box. The PostalAddress Property Wizard enables the setting of these properties. Read/write String.
Syntax
expression.PostalAddress
expression A variable that represents a TextBox object.
Remarks
For processing the conversion, correct settings are necessary for all properties of a field or text box that will contain a postal code, address, and Customer Barcode data.
For settings, use sections 1 to 3, delimiting with semicolon (;).
Postal code settings
Specifies the type of postal code for the field or text box.
| Section | Description |
|---|---|
| 1 | Specifies the field or text box for Prefecture names. |
| 2 | Specifies the field or text box for City/Ward/County. |
| 3 | Specifies the field or text box for Street/Town/Village. |
Address settings
Specifies that the field or text box contains a postal code or Customer Barcode data.
| Section | Description |
|---|---|
| 1 | Specifies the field or text box for postal code. |
| 2 | Specifies the field or text box for Customer Barcode data. |
Note
Two semicolons are required at the end of the value.
Customer Barcode data settings
Specifies the type of Customer Barcode data in the field or text box. This setting is the same as the field or text box for postal code.
| Section | Description |
|---|---|
| 1 | Specifies the field or text box for Prefecture names. |
| 2 | Specifies the field or text box for City/Ward/County. |
| 3 | Specifies the field or text box for Street/Town/Village. |
The postal code consists of three address items: Prefecture, City/Ward/County, and Street/Town/Village. Sections in the PostalAddress property of a field or text box for a postal code can be omitted. The following table shows how to omit sections from the property setting.
| Property settings | Address input in field or text box |
|---|---|
| Address1 | Address2 | Address3 |
| Address1 | Prefecture+City/Ward/County+Street/Town/Village |
| Address1; | Prefecture |
| ;Address1 | City/Ward/County+Street/Town/Village |
| ;Address1; | City/Ward/County |
| ;;Address1 | Street/Town/Village |
| Address1;Address2 | Prefecture | City/Ward/County+Street/Town/Village |
| Address1;Address1 | Prefecture+City/Ward/County+Street/Town/Village |
| Address1;Address2; | Prefecture | City/Ward/County |
| Address1;Address1; | Prefecture+City/Ward/County |
| ;Address1;Address2 | City/Ward/County | Street/Town/Village |
| ;Address1;Address1 | City/Ward/County+Street/Town/Village |
| Address1;Address2;Address3 | Prefecture | City/Ward/County | Street/Town/Village |
| Address1;Address2;Address2 | Prefecture | City/Ward/County+Street/Town/Village |
| Address1;Address1;Address2 | Prefecture+City/Ward/County | Street/Town/Village |
| Address1;Address1;Address1 | Prefecture+City/Ward/County+Street/Town/Village |
Note
The postal code converter program has been developed and licensed by Advanced Giken Corporation for Microsoft Corporation.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.