Subform to show only value

[tom]

I created a subform based on a query, and everything
works alright except I dont want all the extra stuff
in the box. I just want the box to show the value
and nothing else. If I make it the size I want it only
shows "record:" on a bar and no values. Of course
if I make the box larger it shows the values and everything
but I dont want that.

How to do this?

 

[Guest]

You are probably selecting all fields. Change the SELECT * to the name of
the field you want to see.