Report printing unknown blank lines.

[dgrzalja]

Hi!


I have a report that has one field in Details section, it's a text box that prints out fields in a table.

The field is called add, and is a memo (rich edit).
This field usualy contains one or two sentences of add's for newspapers that i write for my firm.

I need the text box to automaticaly expand verticaly if the content is 2 large.
So i set the "Can grow" option, but a problem arises, i get like 3 normaly printed ads, and then blank line.. Like the following:

This is add number 1, prints ok.

This is add number 2, prints ok.

This is add number 3, prints ok.


This is add number 4, does not print ok, 2 blank lines in between.


This is add number 5, does not print ok, 2 blank lines in between.


And so on...

What is the problem? When i deactivate "Can grow", problem disapears, but then i can't see all my add's since some are too big to fit??

How can i fix this?? Please help, it's urgent!!!

[RuralGuy]

Have you set the Detail Section to CanGrow as well? The next step would be to post the db so we can look at it.

[dgrzalja]

Yes, i set it to Can Grow, and can Shrink.

My Database is:

Table -> Appartments

Rows: ID(autoincrement), IDMyN(text-my personal ref), ADD(memo, rich text)

This would be my example add:

Somewhere, house, 100m2, with 2000m2 garden, beautiful view of the sea,
500.000€. Tel. 000/000-0000. Agency Name.

I have 4 add's now since i'm testing if this database is working, but usually i would have like 270 adds like this, that's why it's not good to have that lines when i would send them to newspapers...

Can u help?

[dgrzalja]

Ok, i think i found the problem, it has something to do with the rich text option in the memo, when i turn this off, and set the field to just normal text, problem dispears??

Can i resolve this or do i have to use HTML tags manualy, and set the text box of the report to rich text??

[RuralGuy]

You could try that but I'm not sure you will find a solution that wat. You may need to use a subform in continuous form mode and put your ad's in separate records.

[dgrzalja]

Ok, i solved the problem.

When i put the memo field on rich text, i got the empty lines, but when i returned it to plain text, problem disappears.

I then inserted a textbox into my form for add entry and changed it to rich text, so when i enter the adds, i can still bold them and everything, they get stored in db along with html tags, but display properly in my report.

Only down side is that i have to use PDF to get the output to a file right, since in word i don't see text bolded..

Does someone know how to add a button to export to PDF?
And can i even add a button to export to a file and send to email??

[RuralGuy]

I've had good success with Stephan Lebals code.

[dgrzalja]

Ok, i succeeded in exporting to PDF.

One more question, i tryed to export to RTF, but no formatting was present, my bold words are gone.. Is it possible to convert to DOC (Word) format and preserve formatting??

[RuralGuy]

Have you looked at these links yet?

[dgrzalja]

I dont get it, how to incorporate export to DOC format in my project with that?
It exports, but just images, i can't edit text!?

[RuralGuy]

I guess I just can't help you there. Maybe someone else will have a suggestion.