Put field value in variable during editing

[ino_mart]

All

• In Access 2007 I have a form with 2 textboxes named "txtText" and "txtPreview".

• I defined some keywords such as [[First Name]], [[Last Name]], [].
  [*]There is also a button "Preview" which shows the result in txtPreview where the keywords are replaced by its corresponding values.
  [*]txtText is bounded with field "Text" in table "tblTemplates".
  [/LIST]
  [U]Example[/U]
  txtText = "The emailaddress of [[First Name]] is [[Email]].
  After pressing on "Preview" this displays "The emailaddress of John is John@example.com" in txtPreview
  
  [U]Problem[/U]
  I want to have "txtPreview" updated whilst the user is editing txtText. So with every keypress, that change should also be visible in txtPreview. This can be done by using the "KeyUp"-event.
  
  However, as txtText is currently in "edit"-mode, the code keeps using the original value instead of the modified and txtPreview does not show the modified version.
  
  Does someone have a solution?
  
  Regards
  Ino

 

[vbaInet]

Problem
I want to have "txtPreview" updated whilst the user is editing txtText. So with every keypress, that change should also be visible in txtPreview. This can be done by using the "KeyUp"-event.

It is the On Change event, not the Key Up event and in this event you need to use the Text property not the Value property.