PostalAddress Property

Microsoft Access Visual Basic

expression.PostalAddress Property

expression    Required. An expression that returns one of the objects in the Applies To list.

Remarks

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  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.