By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 1,168 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 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?
1 Week Ago #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,054
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.
1 Week Ago #2

Post your reply

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