[AccessD] Combo box puzzle

[Stuart McLachlan]

What are the "Control Source", "Row source", Bound column" in "Data" propertiess and 
"Format and COlumn Widths" in "Format" properties?


"The date field is set to 'short date' or 12/14/2017 and 12/15/2017." and "The field
is set to short date."

A "date field" is actually a date/time field - which stored a number where the integer part is 
number of days since 1/1/1900 (?) and the fractional part is the time.  You can't "set it to 
'short date'".

You probably mean that the default display formats are set to "Short Date" - which is only in 
the form "mm/dd/yyyy" if that is the way your particular computer is configured.   On mine it 
would display as "14/12/17".and "15/12/17"  :)

I never define display formats in tables - that's what the front end is for! - it can cause all 
sorts of problems.

Try removing formatting from the table definition.





On 28 Oct 2017 at 15:21, Tina N Fields wrote:

> Hi,
> 
> There is a table with just two date records - December 14, 2017 and
> December 15, 2017. These are pickup dates for Christmas food baskets.
> The date field is set to 'short date' or 12/14/2017 and 12/15/2017.
> 
> The selected date is to be stored in a date field in the family record
> in the households table.
> 
> On the data-entry form, I placed a combo box (using the wizard), to
> select the values from the tblChristmas_Pickup_date table and store it
> in the HH_Christmas_Date field in the tblHouseholds table. The field
> is set to short date.
> 
> Testing the data entry, as soon as I select the date from the combo
> box, I get this error:
> 
> The value you entered isn't valid for this field.
> For example, you may have entered text in a numeric field or a number
> that is larger than the FieldSize setting permits.
> 
> I can go into the tblHouseholds table and put the date in that field.
> Then, when I attempt to view the record in the form, I get the same
> error.
> 
> What the heck am I doing wrong?
> 
> Thanks,
> T
> 
> -- 
> Tina Norris Fields
> 231-322-2787
> tinanfields-at-torchlake-dot-com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>