Search results

What is the I want to update is in a table? Will the forms! expression still work fore a table? P

I tried with the following: Left([Contacts].[Alternate Email Address 1],InStr([Contacts].[Alternate Email Address 1],"#")-1) But I get "Undefined function Left in expression error ...??? Peter

Thanks again. is "Me" the name of the Table the data is in? and I assume textfield name is as it appears to be ....

Call me thikc if you like :-) but where would I use that expression? Me.TextFieldName = Left(Me.TextFieldName, Instr(Me.TextFieldName,"#")-1) PR Would I need to run an uipdate query on the field inm question? Or something else?

Big thanks. I will look at them. I'm not a programmer so the sytax is a bit bewildering to me. Nevertheless I will have a go. At least you've pointed me in the rigth direction! Much obliged. Peter R

Hi. As a newbie, I hope no-one flames me for this :-( I have a porblem and hope someone can assist. Unknowingly, I changed a field in my database that had email addresses in it formatted as hyperlinks to text. (I had a good reason, believe me). Anyway, the field now contains the email address...