Continuing on with my form,
I'm trying to alter what a user entered, in a textbox, into a different string/value.
Specifically, if a user enters a date as 13.4.5 16.7.8 then I want it converted to 2013/4/5 16:07:08
(A funny side note, Access doesn't see an error with that input, put it swaps the time for the date and gives an unexpected result)
My function returns a string for the correctly formatted "." date,
but when I try to save it, anywhere, there's a run-time error (debug goes to the highlighted line).
It seems odd that the textbox entry can't be altered.
I've tried the .text, .value, control name and all give the same error.
Am I going about this correctly?
Is this something Access doesn't allow?
Is there a better place to do this than in BeforeUpdate of the control?
I've researched this on Google. and most of the problems/responses don't apply, but the few that do offer no solution.