Leo_Polla_Psemata
Registered User.
- Local time
- Today, 15:23
- Joined
- Mar 24, 2014
- Messages
- 364
Hi,
In one form, I have a long text field, named text2.
I copy and paste in the field text2 details in bulk, then very easily i update other fields in the same form.
The problem is that the data source contains "tabs", CHR(9)
I need to make one "before update event" which will kill all the CHR(9) from the field
This works just perfect in a query, how can i turn it into a vba "before update" ?
Replace(Text2,Chr(9),"")
In one form, I have a long text field, named text2.
I copy and paste in the field text2 details in bulk, then very easily i update other fields in the same form.
The problem is that the data source contains "tabs", CHR(9)
I need to make one "before update event" which will kill all the CHR(9) from the field
This works just perfect in a query, how can i turn it into a vba "before update" ?
Replace(Text2,Chr(9),"")