Program in report datasource

[kai]

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

[Larry Linson]

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

"kai" <ka******@earthlink.net> wrote in message
news:M8******************@newsread1.news.pas.earth link.net...

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

[Pieter Linden]

"kai" <ka******@earthlink.net> wrote in message news:<M8******************@newsread1.news.pas.eart hlink.net>...

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

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

Kai