Access 2003基于十进制数创建文本 [英] Access 2003 create text based on decimal numbers

问题描述

我有一个表（TblItems），字段长度，宽度和高度为

十进制字段。我还有字段Desc，一个文本字段。


在一个表格中，我在更新后创建了这行代码：

Desc = Lenght& " x &安培;宽度和宽度" x &安培;高度


如果值为100,100,100，结果为100 x 7920 x 100.


无论我投入什么价值宽度字段它与

相同7920.为什么？


这可能有一些愚蠢的简单解决方案........

I have a table (TblItems) with fields Lenght, Width and Height as
decimalfields. I also have the fields Desc, a text field.

In a form I have created this line of code after updating:
Desc = Lenght & " x " & Width & " x " & Height

If the values is 100, 100, 100 the result is 100 x 7920 x 100.

No matter what value I put into the width field It comes out with the
same 7920. Why??

This probably has some silly simple sollution........

推荐答案

你应该丢弃Desc字段！它不是必需的，而且会变成问题。当你需要表格或报告中的描述时，你应该创建

表达式，其公式类似于你在帖子中显示的公式。


Re ：代码问题---

宽度是一个保留字，用于表示窗体上的控件宽度或

报表。默认的测量单位是一个twip，它是

英寸的1/1440。因此，如果你得到7920缇，你的文本框的宽度是5.5

英寸。


PC数据表

为客户提供A访问，Excel和Word帮助资源

应用程序
re ****** @ pcdatasheet.com


" Ulv" < la ** @ johs-nilsen.nowrote in message

news：11 ********************* @ g4g2000hsf.googlegrou ps .com ...

You should discard the Desc field! It is not needed and will become
problematic. When you need the Desc in a form or report, you should create
the expression with a formula similar to the one you show in your post.

Re: problem with your code ---
Width is a reserved word used to express the width of a control on a form or
report. The default unit of measurement is a twip which is 1/1440 of an
inch. So if you are getting 7920 twips, the width of your textbox is 5.5
inches.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com


"Ulv" <la**@johs-nilsen.nowrote in message
news:11*********************@g4g2000hsf.googlegrou ps.com...

>我有一个表（TblItems），字段长度，宽度和高度为

十进制字段。我还有字段Desc，一个文本字段。


在一个表格中，我在更新后创建了这行代码：

Desc = Lenght& " x &安培;宽度和宽度" x &安培;高度


如果值为100,100,100，结果为100 x 7920 x 100.


无论我投入什么价值宽度字段它与

相同7920.为什么？


这可能有一些愚蠢的简单解决方案........

>I have a table (TblItems) with fields Lenght, Width and Height as
decimalfields. I also have the fields Desc, a text field.

In a form I have created this line of code after updating:
Desc = Lenght & " x " & Width & " x " & Height

If the values is 100, 100, 100 the result is 100 x 7920 x 100.

No matter what value I put into the width field It comes out with the
same 7920. Why??

This probably has some silly simple sollution........

5月28日下午3:20，Steve < s ... @ private.emailaddresswrote：

On May 28, 3:20 pm, "Steve" <[e-mail]:

你应该丢弃Desc字段！它不是必需的，而且会变成问题。当你需要表格或报告中的描述时，你应该创建

表达式，其公式类似于你在帖子中显示的公式。


Re ：代码问题---

宽度是一个保留字，用于表示窗体上的控件宽度或

报表。默认的测量单位是一个twip，它是

英寸的1/1440。因此，如果你得到7920缇，你的文本框的宽度是5.5

英寸。


PC数据表

为客户提供A访问，Excel和Word帮助资源

应用程序

resou ... @ pcdatasheet.com


" Ulv" < l ... @ johs-nilsen.nowrote in message


新闻：11 ********************* @ g4g2000hsf.googlegrou ps.com ...

You should discard the Desc field! It is not needed and will become
problematic. When you need the Desc in a form or report, you should create
the expression with a formula similar to the one you show in your post.

Re: problem with your code ---
Width is a reserved word used to express the width of a control on a form or
report. The default unit of measurement is a twip which is 1/1440 of an
inch. So if you are getting 7920 twips, the width of your textbox is 5.5
inches.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[e-mail]

"Ulv" <[e-mail] in message

news:11*********************@g4g2000hsf.googlegrou ps.com...

我有一个表（TblItems），字段长度，宽度和高度为

十进制字段。我还有字段Desc，一个文本字段。

I have a table (TblItems) with fields Lenght, Width and Height as
decimalfields. I also have the fields Desc, a text field.

在表格中，我在更新后创建了这行代码：

Desc = Lenght& " x &安培;宽度和宽度" x &安培;高度

In a form I have created this line of code after updating:
Desc = Lenght & " x " & Width & " x " & Height

如果值为100,100,100，则结果为100 x 7920 x 100.

If the values is 100, 100, 100 the result is 100 x 7920 x 100.

无论我在宽度字段中输入什么值它都与

相同7920.为什么？

No matter what value I put into the width field It comes out with the
same 7920. Why??

这可能有一些愚蠢的简单解法........-隐藏引用的文字 -

This probably has some silly simple sollution........- Hide quoted text -

- 显示引用的文字 -

- Show quoted text -

非常感谢!!回覆。 desc字段我需要它，以防它后来更改

.....

Thank you so much !! Re. the desc field I need it in case it will be
changed later.....

Re：Desc字段

在你的桌子里有Desc字段仍然是错误的！毫无疑问，

以后会后悔的。


PC数据表

为客户提供访问，Excel和Word帮助的资源

申请
re******@pcdatasheet.com


" Ulv" < la ** @ johs-nilsen.nowrote in message

news：11 ********************** @ w5g2000hsg.googlegro ups.com ...

Re: Desc field
It is still a mistake to have the Desc field in your table!! You undoubtedly
will regret it later.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com


"Ulv" <la**@johs-nilsen.nowrote in message
news:11**********************@w5g2000hsg.googlegro ups.com...

5月28日下午3:20，Steve < s ... @ private.emailaddresswrote：

On May 28, 3:20 pm, "Steve" <[e-mail]:

>你应该丢弃Desc字段！它不是必需的，并且会变得有问题。当您需要表单或报表中的Desc时，您应该使用与您在帖子中显示的公式类似的公式创建表达式。

Re：您的问题代码---
宽度是一个保留字，用于表示窗体
或
报表上控件的宽度。默认的测量单位是缇，是1/1440英寸。因此，如果您获得7920缇，文本框的宽度为5.5英寸。

PC数据表
为客户提供访问，Excel和Word帮助的资源应用程序
resou ... @ pcdatasheet.com

Ulv < l ... @ johs-nilsen.nowrote in message

新闻：11 ********************* @ g4g2000hsf.googlegro ups.com ...

>You should discard the Desc field! It is not needed and will become
problematic. When you need the Desc in a form or report, you should
create
the expression with a formula similar to the one you show in your post.

Re: problem with your code ---
Width is a reserved word used to express the width of a control on a form
or
report. The default unit of measurement is a twip which is 1/1440 of an
inch. So if you are getting 7920 twips, the width of your textbox is 5.5
inches.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[e-mail]

"Ulv" <[e-mail] in message

news:11*********************@g4g2000hsf.googlegro ups.com...

>我有一个表（TblItems），字段长度，宽度和高度为

十进制字段。我还有字段Desc，一个文本字段。

>I have a table (TblItems) with fields Lenght, Width and Height as
decimalfields. I also have the fields Desc, a text field.

在表格中，我在更新后创建了这行代码：

Desc = Lenght& " x &安培;宽度和宽度" x &安培;高度

In a form I have created this line of code after updating:
Desc = Lenght & " x " & Width & " x " & Height

如果值为100,100,100，则结果为100 x 7920 x 100.

If the values is 100, 100, 100 the result is 100 x 7920 x 100.

无论我在宽度字段中输入什么值它都与

相同7920.为什么？

No matter what value I put into the width field It comes out with the
same 7920. Why??

这可能有一些愚蠢的简单解法........-隐藏引用

text -

This probably has some silly simple sollution........- Hide quoted
text -

- 显示引用的文字 -

- Show quoted text -

非常感谢!!回覆。 desc字段我需要它，以防它后来改变了

.....

Thank you so much !! Re. the desc field I need it in case it will be
changed later.....

这篇关于Access 2003基于十进制数创建文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！