This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / Access帮助！！紧急！！非常容易的问题！！in a report...
The control source of a textbox is from a field name InvoiceTerm under Query QAllInfo which is of number type.
I wanna format it to show as "30 Days" using the expression builder (because of the layout, I don't wanna make them two separate textbox and label).. ie. Str([InvoiceTerm]) + " Days" instead of showing it as 30.
But it doesn't recognize any of the expression I put in.
Thanks!
-jeffrey815(Smartiecat);
2003-3-23
{422}
(#1102754@0)
-
你可以在formular中把前面的数字先转成文本，然后合成。
-henhen(哼哼,丫丫);
2003-3-23
(#1102770@0)
-
我用的=Str([InvoiceTerm]) + " Days" 就是这样，但是不可以。给出error.
-jeffrey815(Smartiecat);
2003-3-23
(#1102793@0)
-
你是不是用vb写还是直接在report中，要不试试cstr，再不行试试format语句。
-henhen(哼哼,丫丫);
2003-3-23
(#1102856@0)
-
我是直接写在report中，那个control的control source (property)里。
-jeffrey815(Smartiecat);
2003-3-23
(#1102926@0)
-
用cstr显示Error 0, 用str, 显示#Error
-jeffrey815(Smartiecat);
2003-3-23
(#1102929@0)
-
最简单的，改SQL。
-guestagain(guest again);
2003-3-23
(#1102875@0)
-
这个是Access，改不了，只支持simple sql.
-jeffrey815(Smartiecat);
2003-3-23
(#1102921@0)
-
you must be kidding.
-guestagain(guest again);
2003-3-23
(#1102948@0)
-
用formt(...) + "days" 就行了
-ititit(IT挨踢IT);
2003-3-23
(#1103017@0)
-
up.
-jeffrey815(Smartiecat);
2003-3-23
(#1102840@0)