The number is too large?

[Guest]

Hey guys,

I've been working on an access database project, and everything was going
pretty well since now...

Suddently everytime I open a table, I get an error message "number is too
large". Even though I serched through the entire help-file and googled a lot,
I wasn't able to find any help what so ever with this problem.

I figured the problem might be the width of the combo boxes. They appear
whole screen wide, and look pretty ugly. I don't believe I changed any
preferences... I tried to fix the problem, but ones again without any results.

I'd be more than glad if someone helped me with this problem!

-Niko

 

[Guest]

Hi,

Thank you for your response. Just a minute ago, after several days of
struggling, it just somehow came to me, and i fixed the problem. Because my
access is in finnish, it's hard to explain how, but the error was that he
width of the combo box was too large (57cm+) (Just as i figured). I just
didn't find the way to change it earlier.

However, thank you for help!

-Niko

"Gerwin Berentschot" kirjoitti:

 

[missinglinq via AccessMonster.com]

You don't really tell us much about your db, but my guess would be that maybe
you have something that is calculated at startup time and that you have this
defined as an integer when you really need a single or double instead. Some
native Access functions (Selstart for one) require an integer as an argument,
and can cause Access problems if you try to "overstuff" them.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com