Yes you could use float instead.
But for the entry of the value you better use a string because you can enforce the 2 places decimal without much problem with the string commands. And the backparsing isn't hard with
value# = val(left(check,len(check)-3)) + val(right(check,2))/100.0
where check is the string which represents the value entered
But for the entry of the value you better use a string because you can enforce the 2 places decimal without much problem with the string commands. And the backparsing isn't hard with
value# = val(left(check,len(check)-3)) + val(right(check,2))/100.0
where check is the string which represents the value entered