Concatenating Fields

[dsmith910]

I created a dbase in Access 2000 on a machine with Windows 98. The operating system has now been changed to Windows 2000XP.

Several of my reports concatenate fields to form postal addresses without spaces using =IIF(IsNull([Add1]),"",[Add1]& " " & Chr(13) & Chr(10)) & .... The parameters Chr(13) and Chr(10) insert a space and a line space.

Now my machine is on Windows 2000XP the report asks for the parameter Chr. Does anyone know if these have changed in the new operating system?

 

[VicM]

dsmith910:

I doubt that the functions would have changed in XP. I suspect upon reinstall of Access onto the XP machine, some references were not added.

Open any form or report code module, then select Tools, References... from the menu bar at top. If you can do the same to a non-XP machine where your database works, you can see which references are not showing up under the XP installation.

Unfortunately, I'm not sure which reference that might be. If someone else knows, maybe they can enlighten you. But in the meantime you can do trial and error based on my suggestion.

Hope this helps.

Vic

 

[dsmith910]

Many thanks for the help - unfortunately over the last weekend all the machines in the office were changed to Windows 2000XP - therefore not possible to check what has changed. Will amble round to a friends house tonight to see if her machine at home is still on Win98 to see if I can get the setting from there.

Can you think of any other way of getting rid of empty lines?

Doreen

 

[annsolomon]

Hi dsmith910. I'm running Access 2000 on WinXP also and I can insert carriage returns and line feeds using Chr(13)/Chr(10) with no problem on my reports.

I know that doesn't fix your problem but it should eliminate (or at least reduce) the probability that your new OS is at fault.

Exactly, what is the error message you're getting? Ann

 

[dsmith910]

Hi Ann
When I try to run the report it asks me to 'Enter Parameter Value! on a separate line it says 'Chr'.

No matter what I put in the box provided it then returns the address text box empty except for 'Error'. Its maddening.

Doreen

 

[annsolomon]

Hi Doreen

If you haven't lost a parenthesis in your query, maybe it's a missing library reference. Check it out and if that's not the case let us know so we can put the thinking caps back on. Ann

 

[dsmith910]

Hi Ann

Can't see any missing parenthesis plus the text box exists in 15 reports - difficult to see how they could have have become affected.

Will check out library reference idea.

Thanks for thinking of me!

Doreen