How to make result of query like text box?

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

I have a query that returns one value. I want this to take
as small a space on the form as possible. How to put
it on a form without the scroll bars and all that stuff
I do not need?
 
I have a query that returns one value. I want this to take
as small a space on the form as possible. How to put
it on a form without the scroll bars and all that stuff
I do not need?
Click to expand...

The query returns just one value?
Using an Unbound text control on the form:
=DLookUp("[FieldName]","QueryName")
 
You must log in or register to reply here.

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

Displaying query result on the same form as selection fields 6
Query Results in a Text Box 3
Query Parameter using multiple options 0
how to pass a parameter to a query base of a query that is the base of a report 0
can text box show result of query? 1
Query with 2 field selection criteria 1
Is it possible to use DLOOKUP in a query to bring in a value directlyfrom a control box in a form? 3
Growable Text Box in Report 2

Back
Top