Data Type? 11.55 as Number

[MagM]

Hi, I would like to know what do I set the Number field to in property sect. I want double diget only and 2 decimel places only, eg 25.44. Thanks

 

[pedie]

Hi, I would like to know what do I set the Number field to in property sect. I want double diget only and 2 decimel places only, eg 25.44. Thanks

'm new myself to access, tried looking here and there but I see no option to set the property type to the way you want.
However if you;re updating numbers from form maybe you can try
something like this

[/FONT]
[FONT=Courier New]Sub test101()
Dim ccc As String
ccc = 12.55
If ccc Like "*.*" And Len(ccc) = 5 Then
MsgBox "ok"
Else
MsgBox "not okay"
End If
End Sub[/FONT]
[FONT=Courier New]

 

[xenou]

It's an interesting question. Why would it be a problem if a user entered a value with greater precision?

I.e.,
11.55432
Instead of:
11.55

 

[Norie]

Set Field Size to Single, Format to 00.## and Decimal Places to 2.

This will still allow the user to enter values with more than 2 decimal places. though.

You could set up a validation rule I suppose.

 

[HiTechCoach]

'm new myself to access, tried looking here and there but I see no option to set the property type to the way you want.
However if you;re updating numbers from form maybe you can try
something like this

[FONT=Courier New]Sub test101()
Dim ccc As String
ccc = 12.55
If ccc Like "*.*" And Len(ccc) = 5 Then
MsgBox "ok"
Else
MsgBox "not okay"
End If
End Sub[/FONT]

If the dats is numeric then you really should be using numeric data types.

If ccc Like "*.*" And Len(ccc) = 5 Then

The above has many log errors.

Here are some examples that incorrectly pass your logic:

? "1234." Like "*.*" and Len("1234.") = 5
True

? ".1234" Like "*.*" and Len(".1234") = 5
True

 

[MagM]

Yes you are correct, I set format to .00 & it works. Thanks all