Overwrite mode for textbox controls

Overwrite mode for textbox controls

By default, textbox controls work in insert mode, where each new character never overwrites existing ones. If you wish to implement overwrite mode you can take advantage of the fact that characters pressed by the user replace the currently selected text, if any.

You need to declare a form-level variable that holds the current mode, and modify the KeyPress event of the text box control. You also need to add some code to the KeyDown event procedure, in order to trap the INS key and pass from insert mode to overwrite mode and vice versa:

' form level variableDim overwriteMode As BooleanSub Text1_KeyPress (KeyAscii As Integer)    If overwriteMode And KeyAscii >= 32 And Text1.SelLength = 0 Then        ' we are in overwrite mode, the user hasn't pressed a        ' control key and there's no text currently highlighted        If Mid$(Text1.Text, Text1.SelStart + 1, 1) <> vbCr Then            ' we are not at the end of the current line of text            ' select the next character, so that it will be replaced by            ' key typed by the end user            Text1.SelLength = 1        End If    End IfEnd SubSub Text1_KeyDown (KeyCode As Integer, Shift As Integer)    If KeyCode = 45 And Shift = 0 Then        overwriteMode = Not overwriteMode    End IfEnd Sub

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular