How to count the value of a field

[policechiefwiggum]

Hi All,

I have a field, that i need to put some validation on, in order to pass the field value to another form, previously i've had a hidden caption with

Me.Change_Made.Caption = Me.Change_Made.Caption + 1

in the "onchange" setting, this works fine when text is typed in, however users have started to copy and paste enought charecters to meet the validation, but as they've copyed and pasted the value my currect code only sees this as 1 change. hence the validation failes.

if i could count the number of charecters in the field this would make the validation a bit more robust.
can anyone help?

Thanks in advance

 

[PHV]

Have a look at the Len function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[policechiefwiggum]

PERFECT!
cheers PHV

 

[policechiefwiggum]

Ok, so the Len function works perfectly. but now i'm getting an invalid use of null error.

a quick google has found the Nz function but i'm not sure how to use it correctly.

i've tried

If Me.new_update.Value = Null Then
TestNull = Nz(Me.new_update, 0)
End If

which isn't working either!

 

[PHV]

Why not simply this ?
TestNull = Nz(Me!new_update, 0)
If Len(TesNull) ....

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[policechiefwiggum]

i'm not sure if that would work.
my validation is basically
if the field is 1-9 charecters give message "enter more text"
if its 10 or higher write to database
if its 0 give message "no changes"

the code works fine except for the Null i keep getting

 

[PHV]

the code works fine except for the Null
Which code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886