CanShrink question Access 2000

[JHB]

Hi:

I have a report with a "remarks" field (Memo format) that usually does
not contain anything.The report has that control as the ONLY item in a
line, and it is set to CanShrink=YES! I had expected it not to show
the line on the report if it was empty. Instead the line is there all
the time, but just contains no data. Changing CanShrink to "NO" does
not appear to make any difference. Can someone offer some ideas as to
what is happening? Do Memo fields have weird defaults or something?
The default contents on the field have not been entered, which I
assume results in an empty field. Is this a valid assumption?

Regards

John Baker

 

[Bob Quintal]

m:

Hi:

I have a report with a "remarks" field (Memo format) that usually
does not contain anything.The report has that control as the ONLY
item in a line, and it is set to CanShrink=YES! I had expected it
not to show the line on the report if it was empty. Instead the
line is there all the time, but just contains no data. Changing
CanShrink to "NO" does not appear to make any difference. Can
someone offer some ideas as to what is happening? Do Memo fields
have weird defaults or something? The default contents on the
field have not been entered, which I assume results in an empty
field. Is this a valid assumption?

Regards

John Baker

Does the report section have it's canShrink property also set to
"Yes"?

Are there any vertical lines in that section of the report?

Try setting the control's height property to 0 in design mode, and
enable CanGrow="Yes for the textbox and section, see if it grows to 1
line, which may indicate that some format issue is forcing the blank
textbox to be 1 row high.

 

[JHB]

m:











Does the report section have it's canShrink property also set to
"Yes"?

Are there any vertical lines in that section of the report?

Try setting the control's height property to 0 in design mode, and
enable CanGrow="Yes for the textbox and section, see if it grows to 1
line, which may indicate that some format issue is forcing the blank
textbox to be 1 row high.

No it did not! I honestly did not know the report detail had that as
one of its properties.
Thank you very much indeed -- that opens all sorts of potential for
report formatting!

Thanks again
'
John Baker