Does any one know how to use a bound rich text box on a report.
I have addresses stored in a table with each line being a field, but some lines in some addresses don't have values, so I concatenate the fields putting chr(13) at the end of each line which does have a value.
When I try to show this in a text box that chr(13) is shown as a box, not creating a new line. This is true with char(10), doubles and combination of 10 and 13.
The data can be shown on a form using a bound rich text box, but when I put this on a report I get problems.
When the rich text box is put on the report and it is not bound things are fine. As soon as I set the Control Source property of the rich text box I get an error message of Property cannot be set.
Does any one know either how to use a bound rich text box on a report or a way around this problem.
A single text box reacts the same as on the form described above.
Multiple text box is unacceptable as it leaves blank lines all over the place, and setting can shrink to true does not work if you have other controls on the report next to the control which should shrink.
I have addresses stored in a table with each line being a field, but some lines in some addresses don't have values, so I concatenate the fields putting chr(13) at the end of each line which does have a value.
When I try to show this in a text box that chr(13) is shown as a box, not creating a new line. This is true with char(10), doubles and combination of 10 and 13.
The data can be shown on a form using a bound rich text box, but when I put this on a report I get problems.
When the rich text box is put on the report and it is not bound things are fine. As soon as I set the Control Source property of the rich text box I get an error message of Property cannot be set.
Does any one know either how to use a bound rich text box on a report or a way around this problem.
A single text box reacts the same as on the form described above.
Multiple text box is unacceptable as it leaves blank lines all over the place, and setting can shrink to true does not work if you have other controls on the report next to the control which should shrink.