Check for Null Date

[John Conklin]

Hello all,

I have a form that populates dates on a subform based on the current status
value.

On opening the form I want to check the current status and the corresponding
date field, and if the date field is blank put today's date in.

How do I check for a blank date field? Here is part of my code:

If Me.Current_Status = "Issue Assignment" And
Forms![frmIssueLog]![frmStatusTimes].Form![IssueAssignBegin] = "" Then
Forms![frmIssueLog]![frmStatusTimes].Form![IssueAssignBegin] =
Date

Any and all help is greatly appreciated.

Thanks,
~John

 

[Arvin Meyer]

Instead of:

Forms![frmIssueLog]![frmStatusTimes].Form![IssueAssignBegin] = ""

Try:

Len(Forms![frmIssueLog]![frmStatusTimes].Form![IssueAssignBegin] &
vbNullString) = 0

vbNullString is a constant that has a value of 0 if either Is Empty or Is
Null is true. The length of the string will exceed 0 if anything at all is
in the textbox.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[John Conklin]

Arvin,

Thanks for the reply.

However, it is still changing the date to the current date even if the field
is populated with a date.

Any suggestions?

~John

Instead of:

Forms![frmIssueLog]![frmStatusTimes].Form![IssueAssignBegin] = ""

Try:

Len(Forms![frmIssueLog]![frmStatusTimes].Form![IssueAssignBegin] &
vbNullString) = 0

vbNullString is a constant that has a value of 0 if either Is Empty or Is
Null is true. The length of the string will exceed 0 if anything at all is
in the textbox.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

Hello all,

I have a form that populates dates on a subform based on the current status
value.

On opening the form I want to check the current status and the corresponding
date field, and if the date field is blank put today's date in.

How do I check for a blank date field? Here is part of my code:

If Me.Current_Status = "Issue Assignment" And
Forms![frmIssueLog]![frmStatusTimes].Form![IssueAssignBegin] = "" Then
Forms![frmIssueLog]![frmStatusTimes].Form![IssueAssignBegin] =
Date

Any and all help is greatly appreciated.

Thanks,
~John

 

[John Conklin]

Never mind, I had an error in my code and had this current status listed
twice, so it was getting changed further down in my code.

Thanks again for your help.

~John

Arvin,

Thanks for the reply.

However, it is still changing the date to the current date even if the field
is populated with a date.

Any suggestions?

~John

Instead of:

Forms![frmIssueLog]![frmStatusTimes].Form![IssueAssignBegin] = ""

Try:

Len(Forms![frmIssueLog]![frmStatusTimes].Form![IssueAssignBegin] &
vbNullString) = 0

vbNullString is a constant that has a value of 0 if either Is Empty or Is
Null is true. The length of the string will exceed 0 if anything at all is
in the textbox.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

Hello all,

I have a form that populates dates on a subform based on the current status
value.

On opening the form I want to check the current status and the corresponding
date field, and if the date field is blank put today's date in.

How do I check for a blank date field? Here is part of my code:

If Me.Current_Status = "Issue Assignment" And
Forms![frmIssueLog]![frmStatusTimes].Form![IssueAssignBegin] = "" Then

Forms![frmIssueLog]![frmStatusTimes].Form![IssueAssignBegin]

=