I have an append query that is appending to a text field. However, I have some special characters that is causing it not to append because of a data type mismatch. Does anyone know which characters will not append? Thanks for your help.
Special Characters (1 Viewer)
- Thread starter scgoodman
- Start date
- Local time
- Today, 23:04
- Joined
- Sep 12, 2006
- Messages
- 15,662
i can't think you would get a mismatch
you might get a problem if you try and paste chars including chr(0) - as that might "kid" access into wrongly thinking the string has ended - but I struggle to see why you would get a type mismatch.
Are you sure it is this field giving you the problem, rather than another field?
you might get a problem if you try and paste chars including chr(0) - as that might "kid" access into wrongly thinking the string has ended - but I struggle to see why you would get a type mismatch.
Are you sure it is this field giving you the problem, rather than another field?
