Data gets cut off after 20 characters
I have a subreport that queries data from a table. The data is first and last name and displays it on the form.
The problem I am having is that the last name column on the database has a size of 25 characters, anytime a last name is greater than 20 characters in size, it will only display the first 20 characters, and nothing after that.
I have verified that the field is wide enough to fit this information, I have also added text following the last name and it all displays correctly, however the last name is always cut off at the 20th character.
Does anyone know why this is happening?
Thanks in advance.
Ludek Uher replied
I have also found out that the column size for last name was 20 characters and has been changed to 25 recently (after the report was created).
Could this have anything to do with it.
- Yup, it sure could. Open the report in the designer and go to the File menu. Select Report Options. Find "Verify on first refresh" and enable that. You might as well enable "Verify stored procedures on first refresh", while you're at it. Save the report. See if that helps.
You can also do similar verify in code: