My formula:

Mid([f1],InStr(10,[f1],": ")-1)

returns #ERROR if the value is blank, otherwise works fine. Any ideas how to
change my formula to get beyond the #ERROR?


Access 2007.


Thanks

mike

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200906/1