[AccessD] AC2010-a pioneer with more arrows in the back...

Sorry Susan...I agree with your Friday-lighten-it-thesis....
But getting back to the matter: Too many undocumented restrictions on this
"new feature".
In fact, Stuart's expression should have been supported....as should have
mine.
Who's beta testing this "stuff" ?
Poorly done. Period.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Friday, May 11, 2012 7:28 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] AC2010-a pioneer with more arrows in the back...
>
> >
> > Format$(Product_PK,"0000" & Left$([Product_Descr],4)
> >
> > It threw the helpful error:
> >
> > "The expression Format$(Product_PK,"0000" & Left$([Product_Descr],4)
> > cannot be used in a
> > calculated column"
> >
> > A bit of testing reveals that you can't use Format/Format$ in a
> calculated
> > field.
> >
>
> ========In all fairness, formatting a value isn't the same as a
> calculated
> column -- gentlemen, light your arrows!!!!! :) It's Friday, it's after
> 5:00
> pm and well...
>
> Susan H.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com