Help, wierd thing happening

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

r. howell - 26 Sep 2005 20:45 GMT

I have a fairly complicated report, based on a query.

In the query, there is an expression which uses Switch to add words to some
underlying data, depending on what that data is, to produce a field I call
"AltWds".
This is working fine, if I run the query by itself.

In the detail field of the report, I have an unbound textbox with the
Control Source
=IIf([CtDetails]=1,Null,[AltWds])

For some reason, this is returning, for all details, the value it should
have for the first Detail.

I have another unbound textbox in the same field with the control Source
=IIf([CtDetails]=1,Null,[AltDesc])

This is working just fine. The only difference I can see is that the first
is based on an expression in the query while the second is based on
underlying table data. But that shouldn't make a difference, should it? Can
anyone help me out here?

Thanks in advance.

Reply to this Message

TerryC - 27 Sep 2005 02:02 GMT

Make sure your "unbound textboxes" are not named the same as a field in your
report record source. eg. altwds or altdesc. This can cause Access no end of
confusion.

HTH

Terry

> I have a fairly complicated report, based on a query.
>
[quoted text clipped - 19 lines]
>
> Thanks in advance.

Reply to this Message

r. howell - 28 Sep 2005 14:32 GMT

Thanks for the suggestion, but that's not it. Any other ideas?

> Make sure your "unbound textboxes" are not named the same as a field in your
> report record source. eg. altwds or altdesc. This can cause Access no end of
[quoted text clipped - 27 lines]
> >
> > Thanks in advance.

Reply to this Message

r. howell - 28 Sep 2005 15:34 GMT

OK, this hasn't gotten me any farther, but perhaps it will help someone else.
I simplified the code in the text boxes to try to see where the problem is.
If the text box says [AltWds] all is well.
If it says =[AltWds], my problem comes back. Any ideas? Thanks

> Thanks for the suggestion, but that's not it. Any other ideas?
>
[quoted text clipped - 29 lines]
> > >
> > > Thanks in advance.

Reply to this Message

TerryC - 30 Sep 2005 05:26 GMT

Sorry about the delay in getting back to you ...... the slave drivers here
have had me working*&?!

A couple of things to check. Is your textbox in the detail section of your
report? Do the other fields in the report section reflect what you expect to
see? And as a double check the query is definitely returning different data
in the [altwrds] than what is displaying on the report?

I am running out of ideas ...... if anyone else has some input .....

Terry

> OK, this hasn't gotten me any farther, but perhaps it will help someone else.
> I simplified the code in the text boxes to try to see where the problem is.
[quoted text clipped - 34 lines]
> > > >
> > > > Thanks in advance.

Reply to this Message

r. howell - 30 Sep 2005 21:28 GMT

Thanks for getting back at all. Unfortunately, it's still a no go. The
textbox is inthe detail section. The box right next door (also in the detail
section) functions perfectly. The underlying query runs fine when it's run
on its own. I have tried repairing and compacting the database. I have tried
deleting the control and making a new one. I am at my wit's end.

> Sorry about the delay in getting back to you ...... the slave drivers here
> have had me working*&?!
[quoted text clipped - 46 lines]
> > > > >
> > > > > Thanks in advance.

Reply to this Message