Prev: Need a database for horse racing - stevie PIMPS again!
Next: Click to scroll
From: Dirk Goldgar on 1 Mar 2010 19:09
"David" <NoWhere(a)earthlink.net> wrote in message
news:eLRXU3YuKHA.732(a)TK2MSFTNGP06.phx.gbl...
> Mr. Goldgar thanks for responding.
>
> My typepo, s/b .Text not .txt
>
> and Yes, I am looking to screen Empty textboxes prior to Adding or Editing
> in an Access DB.
>
> Not sure what you gain by using "& vbNullString" ??
> I believe either
>
> mine (with correction)
>>> If Len(txtName.Text) > 0 Then
>
> or yours
>
>> If Len(txtYourTextbox & vbNullString) > 0 Then
>
> will work.

They are not the same. In Access, unlike VB, the .Text property is only for
special use, and can only be read when the control has the focus. The Value
property (which is the default property of a text box) can be accessed at
any time, no matter where the focus is.

> Was hoping there might be a better way (e.g. some default you could set on
> the Access field) for example?

It isn't clear to me what you want to do, so I can't suggest a better way.
If you'd like to explain in more detail what you have and are attempting to
accomplish, maybe I can give you better help.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: De Jager on 13 Mar 2010 12:55

"David" <NoWhere(a)earthlink.net> wrote in message
news:e$nfsfYuKHA.2436(a)TK2MSFTNGP04.phx.gbl...
>I have a number of textboxes which may or may Not be Empty.
> I don't use Resume Next
>
> Is there anyway besides screening each field such as:
>
> If Len(txtName.txt) > 0 Then
> !fldName = txtName.txt
> End If
>
> to keep the ".Edit" or ".Add" from generating an error if the textbox
> is Empty.
>
> Thanks
> David
>

From: joelgeraldine on 17 Mar 2010 09:11
imm�m

"David" <NoWhere(a)earthlink.net> a �crit dans le message de groupe de
discussion : e$nfsfYuKHA.2436(a)TK2MSFTNGP04.phx.gbl...
> I have a number of textboxes which may or may Not be Empty.
> I don't use Resume Next
>
> Is there anyway besides screening each field such as:
>
> If Len(txtName.txt) > 0 Then
> !fldName = txtName.txt
> End If
>
> to keep the ".Edit" or ".Add" from generating an error if the textbox
> is Empty.
>
> Thanks
> David
>
First  |  Prev  | 
Pages: 1 2
Prev: Need a database for horse racing - stevie PIMPS again!
Next: Click to scroll