Okay, I have a strange problem. I have an Access database which I transferred over to a laptop with a very high screen resolution.
When I copied the database back to my desktop all the textboxes in the reports show no values but instead just show #. If there's one number present I see #, three numbers shows ###, dates show as ######. All textboxes are affected; the label boxes are fine.
Changing the box size has no affect. Nor does changing the font size or weight.
If I go into Layout View, select a box and press F2, the number suddenly shows up.
You have the same thing sometimes when you move an Excel document from one computer to another. On one the width of the column shows all of the data while on the other computer it shows #### and you have to enlarge the column size to accommodate the data. But in this case I can't seem to change anything on the report design to make the numbers visible. Even creating a new report still shows ## instead of the numbers. So the problem is not specific to the report design but seems to be with the database. I've tried compacting/repair but that does nothing.
Somehow it appears that the file has taken over the higher resolution from the other computer. If I transfer it back to the laptop everything is fine. Tables and queries are fine. Only reports are affected.
Does anybody have an idea how to solve this? Incidentally, the version of Access used on both computers is the same.
When I copied the database back to my desktop all the textboxes in the reports show no values but instead just show #. If there's one number present I see #, three numbers shows ###, dates show as ######. All textboxes are affected; the label boxes are fine.
Changing the box size has no affect. Nor does changing the font size or weight.
If I go into Layout View, select a box and press F2, the number suddenly shows up.
You have the same thing sometimes when you move an Excel document from one computer to another. On one the width of the column shows all of the data while on the other computer it shows #### and you have to enlarge the column size to accommodate the data. But in this case I can't seem to change anything on the report design to make the numbers visible. Even creating a new report still shows ## instead of the numbers. So the problem is not specific to the report design but seems to be with the database. I've tried compacting/repair but that does nothing.
Somehow it appears that the file has taken over the higher resolution from the other computer. If I transfer it back to the laptop everything is fine. Tables and queries are fine. Only reports are affected.
Does anybody have an idea how to solve this? Incidentally, the version of Access used on both computers is the same.