User-defined property as textbox data source

P

Petr Danes

Is it possible to use a user-defined property DIRECTLY as the row source for
a text field on a form? Obviously it is possible to write a custom function
which retrieves such a property, but then it becomes a read-only field. I
want to change it as well. An unbound textbox with code behind works, but
that seems unnecessarily clumsy. None of the variations of syntax I have
tried have worked and I find no mention of such a usage in the archives.

Pete
 
O

OldPro

Is it possible to use a user-defined property DIRECTLY as the row source for
a text field on a form? Obviously it is possible to write a custom function
which retrieves such a property, but then it becomes a read-only field. I
want to change it as well. An unbound textbox with code behind works, but
that seems unnecessarily clumsy. None of the variations of syntax I have
tried have worked and I find no mention of such a usage in the archives.

Pete

--
This e-mail address is fake, to keep spammers and their auto-harvesters out
of my hair. If you want to get in touch personally, I am 'pdanes' and I use
yahoo mail. But please use the newsgroup when possible, so that all may
benefit from the exchange of ideas.
Click to expand...

The closest thing to this is to use a User-Defined Function in the
RowSource, example: = SomeFunction(Arg1,Arg2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dcount() query 1
How can I check a user-defined property in existence? 2
textbox info based on cbo 1
Unbound Textbox formatted as a time format 6
add textbox data to new record without using control source 3
Auto-highlight textbox data? 7
Problem with VBA and assignment of a value 2
row source set via property sheet instead of vba code 0

Top