NOOR MOHAMED
Reputation: 55
TextBox Not Displaying Full Text in Microsoft Access
Currently I'm working on generating report using Microsoft Access. I have encounter problem where I'm unable to display full text in the text box. Control Source for this text box is from SQL Query.
This is example on what I'm getting right now:-
Appreciate any help or suggestion.
Upvotes: 0
Views: 1252
Answers (2)
LungFungus
Reputation: 141
While viewing the form in Datasheet View (not Design View), double-click the edge of the column or drag to desired width. You must save the form for the formatting to stick. The width of datasheet form columns are not tied to the Width property in the property sheet. That's how it works in Access 2010 anyway.
Upvotes: 3
Related Questions
- Access: Text is truncated in display of a textbox with Can Grow=Yes in report
- Textbox null problem
- Text comes in wrong in Access form
- MS Access 2007: Specify Max Length for TextBox on a Form
- Access Form's textbox not showing value
- Access SQL to save value in unbound textbox cannot save more than 255 characters
- VB6 / SQL "Long Text" not comparing correctly (MS Access 2013)
- VBA string length problem
- Textbox not displaying correctly
- ms-access: listbox is not displaying data