By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,730 Members | 1,540 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,730 IT Pros & Developers. It's quick & easy.

Dynamically changing the control source of a field

Seth Schrock
Expert 2.5K+
P: 2,944
I haven't tried anything yet, but I was wondering if anyone else has. I'm wanting to concatenate several fields together along with static text and I want the ability to change the arrangement of the fields in a textbox without having to change the design view. My thought is that I would have a table store the arrangement and when the form or report opens, it gets its control source from the table. Is this just as straightforward as Me.textbox.ControlSource = "=[Field1] & ' - ' & [Field2]"?, getting everything within the double quotes from a DLookup? Is there performance issues doing this? Is there a better system? This idea came to me while I was driving so I couldn't test it out, but I was just wondering if anyone has suggestions or warnings about this idea.
Oct 12 '16 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,107
I think you are on the right track and don't think you will have any problems.

I've done some stuff like this in the past and it's worked great. This article is also changes the RowSource on the fly and Access didn't have a problem performance wise: Combobox Stop Autofilling Text portion from selected item
Oct 13 '16 #2

Seth Schrock
Expert 2.5K+
P: 2,944
Then that is the path I'll take in my testing. Thanks.
Oct 13 '16 #3

Post your reply

Sign in to post your reply or Sign up for a free account.