Results 1 to 2 of 2
  1. #1
    ineptnoob is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    May 2013
    Posts
    1

    Box Type

    What kind of box can I use if I just want to display a name from a table? When I select the text box option in the design view I get two boxes- a text box and a control box. Well if I remove the control box.... the text box also goes away. I just need to be able to pull in info from a table on the back end

  2. #2
    Beetle is offline Unrelatable
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    Camp Swampy (Denver, CO)
    Posts
    207
    When I select the text box option in the design view I get two boxes- a text box and a control box.
    Actually, what you get is a Label and a Text Box;

    Click image for larger version. 

Name:	Capture.PNG 
Views:	9 
Size:	6.5 KB 
ID:	12173

    If you delete the Text Box, the Label will go with it, but you can remove the Label without removing the Text Box.

    The Text Box is what you need for data.

    As far as how you get the data in the Text Box, that depends on the circumstances. If the data you need is in a field in the Record Source of your form, then you can just set the Control Source of the Text Box to that field. If the data is in a different Record Source, then you can use DLookup, or another domain function, to retrieve the value from the other Record Source (Table or Query). This would also be done in the Control Source of the Text Box. Example;

    =DLookup("SomeField", "SomeTable")

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Join Type
    By Andyjones in forum Database Design
    Replies: 1
    Last Post: 02-18-2012, 11:07 AM
  2. How do I fix the #type!
    By Shortone in forum Access
    Replies: 3
    Last Post: 12-02-2010, 11:34 PM
  3. Find as you type
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-31-2010, 04:51 AM
  4. Replies: 2
    Last Post: 03-18-2010, 08:24 PM
  5. Selecting Just One Name Type
    By susan in forum Queries
    Replies: 1
    Last Post: 12-03-2009, 12:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums