MS Access database support - Paste Error - "This Value must be a Number"

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Paste Error - "This Value must be a Number" - Workaround Found

gahagan@gmail.com

2006-04-05, 1:44 pm

If you encounter this error, most likely one of the controls you're
trying to cut/paste is a combo box with a longer-than-average 'Row
Source' value. That, apparently, is the problem. Shorter Row Source
values don't seem to be a problem. (I don't have time to figure out at
what length the error triggers.)

Workaround: Remove the Row Source (you can cut/paste the text somewhere
else), then try cutting/pasting the control(s) again. Then replace the
cbobox's 'Row Source,' and you should be good to go...

I encountered this problem and found this workaround while using Access
2003 Pro on XP Pro.

HTH,
AG

Sponsored Links