Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text box on report formatting problem

Status
Not open for further replies.

ColdDay

Technical User
Nov 30, 2010
92
US
I have a report with a text box to show details/information about records that I have entered in the Add and Edit text boxes on forms.

I would like to be able to enter data into my Add and Edit form pages and have it displayed in the report the same way I entered it. Such as:

Code:
Something.    Something else.        More something.
Some1           Else1                         More1 
Some2           Else2                         More2 
Some3           Else3                         More3

But when I view the info in the report, the info is strung together. I have lost the desired view.

Is this a report or form issue?

How do I get the report to display the info as it had been entered?

Thanks.
 
Check the format properties of the controls on the report and see if that is causing the difference.


The other possibility is that on the form you used an input mask and need to format it on the report to look the same.

Lastly, I guess the report could have multiple values concantenated together in one control...

Those are just the places to look without knowing more.
 
No input mask being used on the forms or the report.

No concatenating happening.

Line spacing = 0

Text format is rich.

Table field type is Memo. (Text will allow only 255 characters and that isn’t enough.)

Form and Report field types are Text Box.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top