#Error

  • Thread starter Thread starter Manish sharma
  • Start date Start date
M

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
 
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
 
Back
Top