Question Special character issue (1 Viewer)

[llkhoutx]

I'm letting users specify the name for a table to be created. Can those names be easily parsed to eliminate special charactes, e.g. "yyy&&" is convertred to "yyy", or does the name have to be parsed character by character. I tried to catch the error fired, but none fired and the table was created with Access 2007?

 

[jdraw]

Why?
Where/how did you try to catch the error or invalid characters?

 

[CJ_London]

Best to capture in the control validation rule

or in the after update event use replace to remove them

Incidentally for table names, best not to allow spaces so definately one to remove

replace(TableName," ","")

 

[gemma-the-husky]

backup

why would the users need to specify a name for a created table?

 

[CJ_London]

Hi gemma,

I was going by this

I'm letting users specify the name for a table to be created

Generally not good practice, I know, but there are times when I have had to provide the facility to build a Create Table query