[AccessD] You cannot record your changes because...

Fortunately I only need to set a couple text fields so I just tested
iserror([fieldname]) as a workaround and used value property of the control
holding the data only if that test was false.

Thanks Mark.
On Oct 24, 2011 4:27 PM, "Mark Simms" <marksimms at verizon.net> wrote:

> As you are aware, Excel employs the Variant data structure.....which allows
> any cell to be a long, string, date, double, boolean, etc. Converting your
> columns to strings may be a crude workaround, but of course, this creates
> other issues as well.
>
>
> > Oh, did I say that was the worst part ...? lol. The underlying table is
> > a linked excel file so I don't think there is anything I can do about
> it?!!
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>