OKay, BUt........................

  • Thread starter Thread starter wade polk
  • Start date Start date
W

wade polk

I need to compare a text/combo box to determine if the user entered data or not. The text box is [plant ID], the code looks like
If [plant ID]=Null Then
DOSOMETHING

I have tried
If [plant ID]=""
and
If IsNull(Plant ID)

Which is the correct way to do this?

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
The correct way is

If IsNull(Me!PlantID) Then

However, it's possible that the text box isn't Null, but contains a
zero-length string. To be sure, try:

If Len(Trim(Me!PlantID & vbNullString)) = 0 Then
 
I need to compare a text/combo box to determine if the user entered data or not. The text box is [plant ID], the code looks like
If [plant ID]=Null Then
DOSOMETHING

I have tried
If [plant ID]=""
and
If IsNull(Plant ID)

Which is the correct way to do this?

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com
Click to expand...

Looks like there is a space in the field name, so you must enclose the
name within brackets.

If IsNull([Plant ID])
 
Fred's eyes are better than mine: I missed the space.

If Len(Trim(Me![Plant ID] & vbNullString)) = 0 Then

(or do yourself a HUGE favour, and don't use special characters, which
includes blanks, in your names!)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Douglas J. Steele said:
The correct way is

If IsNull(Me!PlantID) Then

However, it's possible that the text box isn't Null, but contains a
zero-length string. To be sure, try:

If Len(Trim(Me!PlantID & vbNullString)) = 0 Then

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I need to compare a text/combo box to determine if the user entered data
or not. The text box is [plant ID], the code looks like
If [plant ID]=Null Then
DOSOMETHING

I have tried
If [plant ID]=""
and
If IsNull(Plant ID)

Which is the correct way to do this?

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com
Click to expand...
Click to expand...
 
Private Sub Phone_Enter()
If IsNull(Phone) Then
Phone = "111"
Phone.SelStart = 5
End If
End Sub

And it worked great. Basically it was some code to enter the area code of a phone # so I didn't have to type it manually. The reason selstart is 5 is that the phone # is formatted as such:
(111)111-1111

Hope this helps :)

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng
 
Back
Top