[AccessD] Date in Combo box with SQL view as rowsource returning as string

[David McAfee]

Yup.

I tried pound signs and apostrophes.

I ended up using that script that I posted to list all occurences for the
form reference.
It turns out I was using CDate() around my form references on most of my
queries.

On the occasions that I didn't, there didn't seem to be a row count
difference of the query results.

Maybe Jet infers the data as a date and VBA doesn't.

Thanks,
David

On Thu, Jul 28, 2016 at 5:48 AM, <ewaldt at gdls.com> wrote:

> Re: Date in Combo box with SQL view as rowsource returning as string
>
> Sorry to be simplistic, but you have tried surrounding the date with pound
> signs, right?
>
> Tom Ewald
> Mass Properties
> General Dynamics Land Systems
>
> ----------------------------------------------------------------------
> This is an e-mail from General Dynamics Land Systems. It is for the
> intended recipient only and may contain confidential and privileged
> information.  No one else may read, print, store, copy, forward or act in
> reliance on it or its attachments.  If you are not the intended recipient,
> please return this message to the sender and delete the message and any
> attachments from your computer. Your cooperation is appreciated.
> &&
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>