After conversion to 2010 - field size problem

[DBinPhilly]

I just converted a program to Access 2007/2010 format. It's a program that started in Access 95 so it is very mature.

However, after the conversion, field sizes in many instances have been too small for the size of the data. Instead I have forms and reports with ##### printing instead of the data and I have to expand the field size.

Also I'm now experiencing page overflow on some printed reports - 2nd page is generated where before there was none - all blank. This happens specifically in a report that is fully utilizing all available space on the first page already.

Any ideas?

 

[CJ_London]

I think you mean control sizes?

What I would do is reduce the font size for each control

 

[DBinPhilly]

I think you mean control sizes?

What I would do is reduce the font size for each control

Sorry but not a viable answer.

Many of these are reports going out the door to customers. Many others are being used by company executives. They don't want to use a magnifying glass to read their reports, and we're are dealing with dozens of reports. I'm faced with changing much of the output of the system.

The font is already size 8. I've found that making the font smaller than that is counterproductive.

 

[CJ_London]

Not sure how you are getting this problem then, if the control sizes and font size are the same as per the 'old' version they should still fit.

Two other thoughts - has the font type changed and have the margins changed

 

[DBinPhilly]

Not sure how you are getting this problem then, if the control sizes and font size are the same as per the 'old' version they should still fit.

Two other thoughts - has the font type changed and have the margins changed

To the best of my knowledge, nothing has changed. I'm the programmer and I've changed nothing.
For example, one report which has been operating since about 1996 without revision is now generating a 2nd blank page - the only change being the version of MS Access being used and the conversion to 2007/2010 format (mdb to accdb).

A companion program has forced me to expand field sizes in the printout to allow for the increased space required by the accdb conversion.
One report is not a problem but it has happened many times already, and I'm waiting for the next bomb to go off.

 

[CJ_London]

If you put the two printed reports side by side where is the difference?

I've suggested the margins or fonts may have changed, you've said they haven't so far as you are aware. This kind of implies you haven't checked - and when you do, you might check the papersize hasn't defaulted to legal.

A companion program has forced me to expand field sizes in the printout to allow for the increased space required by the accdb conversion.

Sorry, this doesn't make sense to me

 

[DBinPhilly]

Where is the difference? There is no difference.

Sorry that I was less than clear: there have been no changes in margins, fonts, or font size, in about 18 years. I did the original programming and no one else has touched this program since then other than me.--- the last change to the layout was so very long ago and the program has been working until the changeover to Access 2010.

All other things are equal. No default change to legal. No default change to portrait (it's a landscaped printout).

That's about it. It's making me crazy. If I cannot determine the cause of the overflow, I can't fix it.

I've tried squeezing everything and still no joy.

 

[CJ_London]

Sorry - I'm out of ideas, if everything is the same size it should still print as before.

The only other suggestion I have it to try outputting to pdf first - perhaps can then be emailed rather than posted and save on postage!

 

[DBinPhilly]

Sorry - I'm out of ideas, if everything is the same size it should still print as before.

The only other suggestion I have it to try outputting to pdf first - perhaps can then be emailed rather than posted and save on postage!

Thanks for your help, CJ - actually that's exactly what I am doing, creating a PDF for emailing. The blank page is being created in the regular print out and in the PDF version. Bummer.

I'm going to try reprogramming the whole dang report and see if that does the trick. No one wants to be sent a blank page.

 

[spikepl]

there have been no changes in margins, fonts, or font size, in about 18 years.

The question was not whether YOU have changed anything. The question was whether the margins, fonts and font sizes all are the same in your A2010 version as in the previous one. Did you check? After all something must have changed, if it no loinger fits on the same size of paper as previously.

I don't know how the conversion affects fonts, but the default font for a lot of stuff was Arial, i believe, in A2003 but is Calibri in A2007+.

 

[DBinPhilly]

The question was not whether YOU have changed anything. The question was whether the margins, fonts and font sizes all are the same in your A2010 version as in the previous one. Did you check? After all something must have changed, if it no loinger fits on the same size of paper as previously.

I don't know how the conversion affects fonts, but the default font for a lot of stuff was Arial, i believe, in A2003 but is Calibri in A2007+.

A valid point: unfortunately, they remained ARIAL in the report in question.

As far as I can tell, these defaults only apply to new forms. Forms/reports imported from previous versions apparently remain unchanged.