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

Autofill control source of a text box

P: 1
Hi
I need to fill automatically the control source of text box depend on any excel. For example, I have an Excel file named "values" and When I import this file Access automatically fill the control source of a text box "bounded first column". Can anyone help me?
Mar 11 '19 #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,284
Welcome to Bytes!

Your question is considerably vague, because you haven;t really given us enough information to work with.

If you are importing an Excel Spreadsheet, then, that file may or may not have column headers (Field Names). If it does, then you need to determine how to change the name of your control source based upon the name of thsoe field names.

If this file does not have field names, then just import the fields as "Field1", "Field2", etc. and have the control source for your text box be the same.

I'm not sure I am answering your question, but I'm not sure what you are getting at with your question.
Mar 11 '19 #2

Post your reply

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