[AccessD] Form Validation

[Ryan W]

Err, yes I meant vbWhite, not just White. So since that limits me to just
constants I'll have to go with LONG as you suggested if I want a larger
color palette.



On Sat, Oct 29, 2022 at 7:35 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> On 29 Oct 2022 at 19:06, Ryan W wrote:
>
> > VarChar was to be able use string literals such as "White" as well as
> > maybe the #FFF style color codes, rather than RGB(0,0,0) style. This
>
> Won't work.
>
> Me("txtTest").Backcolor = "White" will just give youa Runtime Error 13 -
> Type Mismatch.
> so  will
> Me("txtTest").Backcolor = "#FFFFFF"
>
> The Backcolor property of a control is a LONG.
>
> You can use
> Me("txtTest").Backcolor = &HFFFFFF
> or
> Me("txtTest").Backcolor = vbWhite
> or
> Me("txtTest") = 16777215
> because they are  all numbers but you can't use a string (variable or
> literal)
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>