[AccessD] length of combo box choice (shorter version)

John Clark John.Clark at niagaracounty.com
Mon Feb 10 13:29:00 CST 2003


OK...down to one single problem...I have figured out my error, w/putting
the value into the table (in the Control Source field). It turns out
that it had to do w/my personal way of doing things...I usually spend
more time designing my tables, so that they are pretty much how they
will be, before I go on to building the form. In this case it burned
me...I had setup the field (numResults) to draw from a combo box, and
from the query "qryResultsCBO." This query is based on a procedure, and
calls the form by name...if the form isn't open, it is blank. 

Everytime, that I was checking my table, I was closing the form first,
and the field was blank. I had left the form open and the data shown.
Where it was being stored, I still do not know...I made all of the
columns visible, but it still did not show anything. However, it was
keeping the data somewhere. I verified that this worked the same with a
report too...form closed, no data...form open, the data prints.

Anywho, I changed the Display Control for this field, in the table, and
it now works.

Now, I just need to set the column widths, to hide the undesireable
columns.




More information about the AccessD mailing list