"Field is too small" error on Access 2002 form

[aperez]

Hello All,

I am sure you all have come across this. But I am getting a "Field is
too small" error while populating an unbound textbox on a form. The
code is like this:

txtOriginName = rst.Fields("FromLocation") & "-" &
rst.Fields("FullFromAddress")

The total length of the text being returned is 68 characters, and the
textbox I am trying to put the string into is unbound.

Any ideas why this is happening?

TIA,
Abner

 

[GreySky]

Do you have a specific format set for the control --
something like "Currency"?

David

 

[aperez]

Hello All,

Just wanted to post a follow-up to this message. It turns out that
although the field was unbound, the code was binding it when the form
was ran. This was done because the field needed to be bound to
different fields depending on certain values. Anyway, one of the
fields it was being bound to was too small to save the text that it
was receiving. I lengthened the field on the SQL Server table and
everything worked well from then on.

Thanks for your responses....
Abner