On screen keyboard (numberpad)

[mad-q]

Hello,

I have made an OSK and am using the code TypeAlphaNum "6". This works fine until (the cell is set to number) I want to enter a decimal point. It treats this as AlphaNumeric (there's a surprise!) but I don't know what the code would be to enter a "." into a number field.

Many Thanks
Iain

 

[pwbrown]

It's probably because by default Access sets numerical fields to Long Integer which doesn't allow decimals. It needs to be set to Single or Double.

 

[mad-q]

Thanks for that, it stops the error saying I can't insert that char but all it does it highlight the field. If I do it in a text box it works fine but just not in a number one.

Thanks