MarcoBechthum
Marco Bechthum
- Local time
- Today, 21:26
- Joined
- Jun 4, 2010
- Messages
- 7
Hello all,
I have designed a database for keeping up all our equipment we have on site for our fire brigade. In total we have 386 hydrants throughout our area. All these hydrants are placed in a database (together with other equipment) providing details of the equipment and X-Y location on a map (simple but big JPEG picture on a form with maximum width and height.
I have made code that makes a new form, puts the big image of the map on the form and places little images on the form to make clear where on the map the equipment is located. This results in a detailed map with 386 little pictures (image controls) on a form.So far this works perfectly.
I know access forms and reports have a maximum numer of controls of 754, so I'm not at the maximum yet. However and here comes the problem.
If I want to print the form (form with the big map and 386 little images for the equipment locations) the printer prints only the first 256 controls(images) and thats it. Also in print preview the first 256 controls are printed from left to right.
When I check the property form.control.count it says 386 wich is the correct number. When I expand the form.controls property in the watches screen (Shift F9) and expand on form.controls you get the complete list of all the controls but this list stops at control nr. 256...
I am confused and do not understand why:
- Access has only limitations of 754 controls on a report or form, my form has les but does not print all of the controls
- When i open the form normally on screen it shows all the controls.
- when i open the form (that does show all controls) in print design mode +- 100 controls are not shown anymore.
Does anybody know if there are also limitations on the printable number of controls? If so, is there any way to bypass this?
Thanks in advance and sorry for the long text.
Regards,
Marco
I have designed a database for keeping up all our equipment we have on site for our fire brigade. In total we have 386 hydrants throughout our area. All these hydrants are placed in a database (together with other equipment) providing details of the equipment and X-Y location on a map (simple but big JPEG picture on a form with maximum width and height.
I have made code that makes a new form, puts the big image of the map on the form and places little images on the form to make clear where on the map the equipment is located. This results in a detailed map with 386 little pictures (image controls) on a form.So far this works perfectly.
I know access forms and reports have a maximum numer of controls of 754, so I'm not at the maximum yet. However and here comes the problem.
If I want to print the form (form with the big map and 386 little images for the equipment locations) the printer prints only the first 256 controls(images) and thats it. Also in print preview the first 256 controls are printed from left to right.
When I check the property form.control.count it says 386 wich is the correct number. When I expand the form.controls property in the watches screen (Shift F9) and expand on form.controls you get the complete list of all the controls but this list stops at control nr. 256...
I am confused and do not understand why:
- Access has only limitations of 754 controls on a report or form, my form has les but does not print all of the controls
- When i open the form normally on screen it shows all the controls.
- when i open the form (that does show all controls) in print design mode +- 100 controls are not shown anymore.
Does anybody know if there are also limitations on the printable number of controls? If so, is there any way to bypass this?
Thanks in advance and sorry for the long text.
Regards,
Marco