Access 97 to 2003 Report Problem

[rkdcomp]

Hi:

Have several Access 97 programs to convert to 2003 and have run into a strange problem with some reports.

I have Control with concatentation within the control (Text and data to form a meaningful paragraph). It works fine in 97, but when converted to 2003 I get #Name? in it's place.

Here is the text in the control: ="|"On "||[DateRcvd]||", you voluntarily notified the ASAP Event Review Committee (ERC) of an incident which occurred on "||[DateIncident]||" involving a possible deviation from maintenance procedures."|"

If I edit the text and replace the "pipe's" with "&" such as: ="On " & [DateRcvd] & " , you voluntary notified the ASAP Event Review Committee (ERC) of an incident which occurred on " & [DateIncident] & " involving a possible deviation from approved maintenance procedures."

The report works fine.

Searched high and low for an answer on the conversion problem. Seems 2003 doesn't like or support the "pipe".

Any sugggestions??

Thanks,

Richard
Tulsa, OK

 

[lupins46]

Interesting.
Can you point to any docs anywhere that say that the pipe symbol could ever be used for concatenation in Access?
I suspect (but don't know) that it might be one of those things that happened to work in one version but is not a documented feature and so there is no responsibilty to carry it forward. As far as I can recall the only symbols ever documented for concatenation are & and +.

 

[rkdcomp]

I would have to go back and check on one thing. This program was written way back and I think it may have been written in Access 2.0. I have some 2.0 books and on Monday I'll see what it says in 2.0 for creating a text box containing concatenation. Maybe that was the case back then and 97 supported it and was dropped in 2000 and up.

One of my follow workers did try and convert this using Access 2000 and got the same problem.

Will have to wait till Monday.

Thanks for the reply.

Richard