Hi everyone,
I'm running Access 2003 under Windows 7 Home Premium.
I have a form with a multi-line text box control, for which the 'Enter Key Behaviour' property is set to "New Line In Field". In some circumstances, the 'Input Mask' property for this text box can be dynamically set to "Password" within the VBA code for the form module, so that the typed text is displayed as asterisks. (I know this sounds strange, but there is a reason for it!)
In this case, when typing text into this text box, if the Enter key is pressed, the cursor goes to the start of the next line as expected. However, when the next character is typed, the cursor reverts back to the line above. It leaves a space (i.e. no asterisk is displayed) at the position where the Enter key was pressed, but then continues to place the typed text as a continuation of the same line.
Can anyone explain why it behaves this way? Is there anything I can do in the VBA code for the form module to make the cursor remain on the next line when further text is typed after pressing the Enter key?
Any suggestions gratefully received!