#Error

[Manish sharma]

Hi,

I have designed one application in MSAccess-97.

One Report in this application has a MEMO field placed
on it with following ControlSource property setting
-----------------
=IIf(IsNull([Narrative]) Or Trim([Narrative])=""," - - ",
[Narrative])
-----------------
The report works properly in MSAccess-97 but when
running in MSaccess - XP version this were the findings:

1. If their is not much data in the field to display say
e.g. 4-5 lines then the field's content is displayed
(Good).

2. A #Error sign appears in the textbox when a lot of
data is stored in the field (as it is a MEMO field).


I am not sure if there is any limitation of TRIM() or
ISNULL function which when passed some heavy amount of
data leads to the #Error to appear?????

Thanks to all in advance.

Manish Sharma

 

[Manish sharma]

Hi,
I forgot to point out that the OFFICE-XP was installed
on WIN-98 system. COULD THIS BE THE CAUSE BEHIND THIS
PROBLEM???

Manish