9数字邮政编码不能用短划线打印 [英] 9 Digit Zip codes not printing with dash

问题描述

我有一个表有两个字段相同格式的TEXT框，字段大小为12（超过必要，但内存不是问题）。在两者上我都为邮政编码设置了输入掩码，格式为00000 \-9999; 0; _。哎呀，我甚至选择用短划线保存邮政编码。


两个相同的字段是ZIP和SHIP8。第一个用于账单地址，后者用于发货。


我的问题出现在查询中。我有一个ZIP和SHIP8的字段。两者都用短划线显示九位数的邮政编码。但是，当我在n表达式中使用它们时，只有ZIP与短划线一起出现，SHIP8以九位数字形式出现。


这是两个表达式。

成功的一个是：

CityStateZip：[City]& ''，''& [国家]& ''''& [邮编]


失败的是：

ShipCityStateZip：[Ship6]& ''，''& [Ship7]& ''''& [Ship8]


我很困惑为什么会这样。


有什么建议吗？


感谢您的预期协助。

解决方案

我不是专业人士，也许你可以设置字段Ship8格式与字段ZIP相同...


我的朋友也说这可能是因为你使用输入掩码而不是数字。 。

这两个字段的格式完全相同。


我必须使用输入掩码而不是数字，因为九位数代码有一个破折号 - 数字字段不能识别它。

< blockquote>你不会说这些文本框控件是否绑定到特定字段但是因为你在查询它们我认为它们是。


你说的是文本的格式框是相同的，但你需要更关注字段的格式。这听起来好像字段有不同的数据类型。

I have a table that has two fields that are identically formatted TEXT boxes with field size of 12 (more than necessary, but memory is not an issue). On both I have the Input Mask set for Zip Codes, formatted as "00000\-9999;0;_". Heck, I even selected to save the Zip Codes with the dash.

The two identical fields are ZIP and SHIP8. The first is used for billing address, the latter is for shipping.

My problem arises in a query. I have a field for each of ZIP and SHIP8. And both show the nine digit zip codes with a dash. However, when I use them in n expression, only ZIP appears with the dash, the SHIP8 comes out as a nine digit number.

Here are the two expressions.
The successful one is:
CityStateZip: [City] & '', '' & [State] & '' '' & [Zip]

The failing one is:
ShipCityStateZip: [Ship6] & '', '' & [Ship7] & '' '' & [Ship8]

I am baffled as to why this is happening.

Any suggestions?

Thanks for the anticipated assistance.

解决方案

i''m not a pro, maybe you can set field Ship8 format same as field ZIP...

my friend also said it could be because you use input mask instead just number..

Both fields do have the exact same format.

I must use an input mask instead of number, since the nine digit code has a dash - a number field would not recognize it as such.

You don''t say if these text box controls are bound to particular fields but since you are querying them I assume they are.

You have said that the formatting of the text boxes are the same but you need to be more concerned about the formatting of the fields. It definitely sounds like the fields have different data types.

这篇关于9数字邮政编码不能用短划线打印的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！