Backspace event text box string formatting not able to delete characters

I'm trying to make a user form for data entry and I have a textbox with tariff codes. the layout is ####.##.##.## which the macro works well at formatting. problem is when you try to backspace you cannot go past any of the periods. I tried to trap a backspace event as a condition for not putting the period but it does not seem to work. also I tried to prevent the user from entering their own periods and that isn't working either.

any help would be much appreciated.

Thanks,

Chris

Please Login or Register  to view this content.

KeyAscii will always be 0 as it's never given a value in the code.

Perhaps you are using the wrong event?

Textboxes have events, eg KeyPress, that are passed KeyAscii representing the key pressed.

Well the code would probably be pretty similar to, if not exactly the same as, the code you already have, it would just be triggered by the KeyPress event rather than the change event.