I am upgrading from Access 97 to Access 2007. The following code works in 97 but not in 07. This code works by copying and pasting selected text into a field. Each time text is copied it pastes the text at the end of the previous text. It fails to work because it overwrites the previous text.
DoCmd.RunCommand acCmdCopy
DoCmd.GoToControl “NamedOther”
SendKeys “{F2}”, True
DoCmd.RunCommand acCmdPaste
SendKeys “/ “, True
Anyone got any ideas – I have tried creating a multivalue field, but this has to be set to Limit to List = Yes
