Question Non Editable Textbox Problem

[byTimber]

This is driving me crazy!:banghead:

I have a simple form with a textbox whose controlsource I get from function:
<
Public ControlSourceName as String
Public Function getControlSourceName()
getControlSourceName = ControlSourceName
End Function
>
I set the controlsource of the textbox to the result of this function
<=getControlSourceName()> having given the name of the field in the current table to the ControlSourceName variable.

ControlSourceName = "1(1)ProblemMemo"

On load the textbox displays 1(1)ProblemMemo !!

If I put text into the field at table datasheet, the text is displayed but I cannot edit it!
If I put another textbox on the form and put it's controlsource directly to
1(1)ProblemMemo field then all is well.

Can anyone figure out what is happening? Please!

 

[byTimber]

Well this site is magical! - after spending 7 hours on this I seem to have sorted the problem. Instead of setting the source in the properties window I passed it to the textbox control as txt.controlsource = controlsourcename.

I thought I had tried that but brain overworked I think....