Form size problem with exporting data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

We made a custom application for one of our clients. Many people use this
application, we developed this application with a screen resolution of 800 x
600, however there are some people that are using 640x480. On one of the
forms we have a cmd button that exports that data to an excel or text file.
The people who are using the 640x480 resolution do not see the whole form,
and when they export, the data gets cut off where the form is cut off eg. if
one of the fields is supposed to be 1000, but because of the size problem
only the first 2 digits are seen, when we export it shows that it is 10
instead of 1000 which is what it is supposed to be. Is there any setting, or
way through code that would fix this problem?

It was developed and being used in access 2003.

Thanks,

Andy Mikkalson
 
Andy,

There are third-party form scaling solutions available that might help:

A shareware version of a form rescaling module I wrote called
ShrinkerStretcher is available at this web site:
http://www.peterssoftware.com/ss.htm

There's a form resizer at http://www.jamiessoftware.tk/ .

The Access Developer's Handbook has form resizing code included:
http://www.amazon.com/exec/obidos/ISBN=0782119417/107-8064361-7403703

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com
 
Thanks for the quick answer Peter, but it turns out I mid-understood the
problem, and it is actually the reports that are having the data cropped off
the end, not the reports. We've tried the the stuff from
http://www.jamiessoftware.tk/ with no luck. Since this is a report problem
not a form problem I'm going to post it in the reports forum.
 
Back
Top