Program in report datasource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kai - 26 Sep 2004 03:51 GMT

Hi,
I try to fill out a textbox value programmaticlly in the datasourse. I
have two textboxs on the report, one "score" textbox connect to table
"score" field, other "grade" is just a textbox.

When the repoert is open, the value in the "grade'' box base one the "score"
value,

score grade

>90 A
>80 B
>70 C

But in the data source window, I cannot program, where should I do it?

Thanks

Kai

Reply to this Message

Larry Linson - 26 Sep 2004 04:58 GMT

If you can do it with an expression, in the ControlSource for the calculated
text box. If you can't, create a function and specifiy the function in the
ControlSource.

Larry Linson
Microsoft Access MVP

> Hi,
> I try to fill out a textbox value programmaticlly in the datasourse. I
[quoted text clipped - 15 lines]
>
> Kai

Reply to this Message

Pieter Linden - 27 Sep 2004 14:21 GMT

> Hi,
> I try to fill out a textbox value programmaticlly in the datasourse. I
[quoted text clipped - 13 lines]
>
> Thanks

Of course, you could base your report on a query and then just drop in
the calculated values...

> Kai

Reply to this Message