From: Chris Robinson 

Thanks for the suggestions John :o)  I think the converting the string in
the code that Ellen mentioned sounds like the one I'll try though - like
you say, it runs when I type manual data.  Must be the form it's pulling it
from.

Chris.

John Beckett wrote:

> Chris Robinson  wrote in message
> news::
> > Here's on for all you Access Guru's ;o)
>
> Uh oh, it's a couple of years since I had a chance to do this sort of
> thing, so I'm just stumbling around here...
>
> No idea, but I would look for code behind the form (i.e. the code that
> runs when you click Save) and search for any "On Error Resume Next"
> statements (comment them out).
>
> Also, I would add something to Save (e.g. MsgBox "In Save")
to prove that
> the code really runs when you click Save. (I guess it must sometimes,
> because you say it works with manual data...).
>
> John

--- BBBS/NT v4.01 Flag-4