[thelist] VB syntax help

[dn at dittodesign.co.uk]

Brilliant Jon, I'm up and running and breathing
a heavy, heavy sigh of relief.

I've wasted days with this *#*%$ Database and
built up a back log of work to boot.

Your a star anytime I can return the favour please let me know.

all the best,

Darren


----- Original Message -----
From: "Jon Haworth" <jhaworth at witanjardine.co.uk>
To: <thelist at lists.evolt.org>
Sent: Tuesday, July 30, 2002 4:04 PM
Subject: RE: [thelist] VB syntax help


> Hi Darren,
>
> > You can't reference the property or method for a
> > control unless the control has the focus.
> > in debug this line is highlighted.
> >
> >   lngFirstNumber = Val(Me.FirstNumber.Text)
>
> OK, that thoroughly threw me... I checked in Access, it turns out you
don't
> need the .Text property at the end.
>
> This works (I've tested it):
>
>   lngFirstNumber = Val(Me.FirstNumber)
>
> It's a bit wierd - in straight VB you can specify the .Text property or
> leave it blank (in which case you get the default property, which in this
> case is .Text anyway). I have no clue why you can't do this in Access.
>
> Cheers
> Jon
>
>
>
>
>
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !