All
i have a spreadsheet system that imports data from an .mdb including a memo box, but the limit on excels displayed and printed data (1024 characters i think) is causing issues!
is anyone aware of a method using VBA that i can use to ensure i can see all the text that is in the memo box not just the 1024(?) characters?
Teshi...
Last edited by teshiburu1988; 06-12-2009 at 02:39 PM.
How many characters do you need?
Do the rest show up in the formula bar?
Entia non sunt multiplicanda sine necessitate
shg,
it is all displayed in the formula bar, but the field is cut off, the memo box on the mdb can take upto one A4 page in size 10 arial, i am unsure as to how many characters that is?
Teshi
Maybe 4000, depending on margins.
Select the cells of interest and run this. I could show over 7000 characters.
Please Login or Register to view this content.
Shg,
Thanks!!!
can this be placed on a button?
Teshi...
Add a button from the Forms toolbar or an Autoshape from the drawing toolbar, right click, Assign macro ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks