>>>I have a field name LEVEL which is a reserved work in SQL Server. So I need to enclose it in delimiters "[]" in the ControlSource of a textbox. I tried the following:
>>>
>>>[MyCursor.level]
>>>
>>>MyCursor.[level]
>>>
>>>But none of it works.
>>>
>>>Is there a way to use the delimiters in ControlSource?
>>
>>What ControlSource of a textbox has to do with a SQL Server?
>>
>>MyCursor.level
>>
>
>I am not sure I understood your question. I have a textbox on a form bound to a cursor MyCursor received from SQL Server. And then when setting form property .BindControls to .T., I get an error. And then I get a message that the textbox is left unbound. Therefore, I thought I need to use delimiters in the ControlSource.
This error you're getting is not connected with the reserved word in SQL Server. It's something completely different. You can use thisform.textbox1.ControlSource = [myCursor.Level] (if in code) with no problems.
If it's not broken, fix it until it is.
My Blog