R
Ron Weiner
Well here is one I have never seen before. I have a customer who has always
had a "if one's good then two is better" mentality. So last month he went
out and bought a bunch of monitors to give each of his employees a dual
monitor system. I have been running dual monitor systems since windows 95
(with a hydra card and special drivers), and would not have it any other
way.
But we are now going over an old access application where we have a
resizable form / subform thingee that users are attempting to maximize
across both monitors. The resizing code throws an error as soon as the
subform is attempted to be set to a value of 31561 or greater. I could
almost understand it if it crapped out at 32768, but what the heck is the
deal with 31560?
Depending on the value I see two different errors.
When width is > 31560 but less then 32768 I get a error # 2100 "The Control
or subform is to large for this location."
When the Width is 32768 or more I get an error # 6 "Overflow"
Has anyone seen anything like this before? The parent form has no problem
stretching itself to the limit of my systems 2580 x 1024 (38700 x 15360 in
Twips) resolution. I have coded around it using some nasty magic number
stuff like this:
Dim l as Long
l = Me.InsideWidth - 180
If l > 31560 Then l = 31560
sfrmTaskSchedule.Width = l
This code prevents Access from throwing an exception, but the subform can no
longer completely fill its container. I am now eagerly waiting to see what
other parts of my program are going to break. :-(
Is there a list of Access Magic numbers anywhere that specify the min and
max values that Access will accept
had a "if one's good then two is better" mentality. So last month he went
out and bought a bunch of monitors to give each of his employees a dual
monitor system. I have been running dual monitor systems since windows 95
(with a hydra card and special drivers), and would not have it any other
way.
But we are now going over an old access application where we have a
resizable form / subform thingee that users are attempting to maximize
across both monitors. The resizing code throws an error as soon as the
subform is attempted to be set to a value of 31561 or greater. I could
almost understand it if it crapped out at 32768, but what the heck is the
deal with 31560?
Depending on the value I see two different errors.
When width is > 31560 but less then 32768 I get a error # 2100 "The Control
or subform is to large for this location."
When the Width is 32768 or more I get an error # 6 "Overflow"
Has anyone seen anything like this before? The parent form has no problem
stretching itself to the limit of my systems 2580 x 1024 (38700 x 15360 in
Twips) resolution. I have coded around it using some nasty magic number
stuff like this:
Dim l as Long
l = Me.InsideWidth - 180
If l > 31560 Then l = 31560
sfrmTaskSchedule.Width = l
This code prevents Access from throwing an exception, but the subform can no
longer completely fill its container. I am now eagerly waiting to see what
other parts of my program are going to break. :-(
Is there a list of Access Magic numbers anywhere that specify the min and
max values that Access will accept