Darren DICK
d.dick at uws.edu.au
Mon Oct 11 18:22:50 CDT 2004
Hi Jeff On forms that have text boxes that are too small, because of real estate issues, to display all the text they can hold, I give a "double click to add/edit data in this field" option. User double clicks and up pops my own hand rolled unbound 'zoom' box. Bigger than the Shift/F2 version (You can add extra features as required) I pass the relevant value to it when opened - allow edits to take place there and save changes once it's closed and refresh the 'calling' field on the 'calling' form HTH Darren -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson Sent: Monday, 11 October 2004 10:47 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Memo field / Text Box issue December of last year Gustav gave us this link. http://www.lebans.com/Report.htm#MixBold I haven't tried it yet... but it looks promising. HTH Jim H. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jeff Barrows Sent: Friday, October 08, 2004 11:22 AM To: AccessD Subject: [AccessD] Memo field / Text Box issue I have a field in a table which is a Memo Field. On the form, I am using a text box to hold the data. The field shows 300+ characters in the table, but when I view it in a form (in Datasheet view) using the Shift/F2 zoom viewer, I can only see 255 characters. When I send the data to an MS Word document, everything is there. When I close the document and the form, then reopen the form, the data still will not appear in the Zoom Viewer. But if I check the table itself, all of the data is there. Any ideas on why I cannot view ALL of the data in the field??? TIA Jeff B -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com