By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,639 Members | 2,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,639 IT Pros & Developers. It's quick & easy.

how to check if there is a date (any date) in txtbox

P: 14
vba access:

I have one txtbox bounded to date in a table.

How to use if settings here?

I have tried this code :

if me.dato.value = "" then
msgbox "Empty"
Else
'Do nothing
end if

nothing happends.
I tried before update and after update

Whats wrong?
Feb 6 '17 #1

✓ answered by jforbes

There are a couple different ways that might work for you:
Expand|Select|Wrap|Line Numbers
  1. If Nz(me.dato.value, "") = "" Then
  2. If me.dato.value & "" = "" Then
  3. If IsDate(me.dato.value) Then

Share this Question
Share on Google+
1 Reply


jforbes
Expert 100+
P: 1,107
There are a couple different ways that might work for you:
Expand|Select|Wrap|Line Numbers
  1. If Nz(me.dato.value, "") = "" Then
  2. If me.dato.value & "" = "" Then
  3. If IsDate(me.dato.value) Then
Feb 6 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.