Export (0) Print
Expand All
Expand Minimize

TextBox.PostalAddress Property (Access)

You can use the PostalAddress Property property to specify or determine the postal code and the Customer Barcode data corresponding to the address information displayed in a specified field/textbox. The PostalAddress Property wizard enables the setting of these properties. Read/write String.

expression .PostalAddress

expression A variable that represents a TextBox object.

For processing the conversion, correct settings are necessary for all properties of field/textbox that will contain postal code, address, Customer Barcode data.

For settings, use section 1 to 3, delimiting with semicolon (;).

Setting for field/textbox for Postal code

Specifies the type of postal code for the field/textbox.

Section

Description

1

Specifies field/textbox for Prefecture names

2

Specifies field/textbox for City/Ward/County

3

Specifies field/textbox for Street/Town/Village

Setting for field/textbox for address

Specifies the field/textbox contains a postal code or Customer Barcode data.

Section

Description

1

Specifies field/textbox for postal code

2

Specifies field/textbox for Customer Barcode data

Note Note

Two semicolons are required at the end of the value.

Setting for field/textbox for Customer Barcode data

Specifies the type of Customer Barcode data in the field/textbox. This setting is the same as the field/textbox for postal code.

Section

Description

1

Specifies field/textbox for Prefecture names

2

Specifies field/textbox for City/Ward/County

3

Specifies field/textbox for Street/Town/Village

The postal code consists of 3 address items; Prefecture, City/Ward/County, Street/Town/Village. Sections in PostalAddress Property property of field/textbox 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/textbox

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

The postal code converter program has been developed and licensed by Advanced Giken Corporation for Microsoft Corporation.

Show:
© 2014 Microsoft