What Function Do I Use To?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a field called "Policy Number" which I defined as the "Number"
datatype. I need to know if the number of characters in that field are either
7 or < 7.
Click to expand...

I tried using the LEN function but it only seems to work on string data types.

What function do I use to determine this?

-Sky
 
9999999?


Sky Warren said:
Hello,

I have a field called "Policy Number" which I defined as the "Number"
datatype. I need to know if the number of characters in that field are either

I tried using the LEN function but it only seems to work on string data types.

What function do I use to determine this?

-Sky
Click to expand...
 
Hi Sky,

Just wondering if you believe in Genies? :)

If Me!Policy >= 1000000 Then
MsgBox "Policy Number has 7 or more characters"
Else
MsgBox "Policy Number has less than 7 characters"
End If

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
 
Hey PC,

I believe in genies now :) I'm glad I found you again. I was thinking of
making a wish but I don't want to put to much strain on your powers ;-) It's
good to hear from you again.

Thanks for everything and for being there whenever the world calls!!

BTW -
Do I ever appreciate how you simplify things whenever you respond. I hope
Microsoft notices this and pays you your worth $$$

-Sky
 
Back
Top