I have a search box that I would like to paste into. I need it to remove trailing spaces after I paste before I hit the Enter key. To get around this, currently I am pasting the data, hit the Del key and then hit the Enter key. I am using the Macro:
SearchForRecord
Object Type
Object Name
Record First
Where Condition = ="[ID] = " & Str(Nz([Screen].[ActiveControl],0))
I have tried to use a RTrim but get an invalid "Where" error. Any suggestions? Thanks in advance.