is there any way to show query result in text box?

[sherif]

i have sub form built on query that running according to two combo box in the main form >
i designed the sub form to show only one field form the query , my problem is i do not like the frame of the sub form and wish if i could show the result in text box instead ,
so are there any way to achieve that ?
regards
sherif

[boblarson]

i have sub form built on query that running according to two combo box in the main form >
i designed the sub form to show only one field form the query , my problem is i do not like the frame of the sub form and wish if i could show the result in text box instead ,
so are there any way to achieve that ?
regards
sherif

First off, you can still use the subform but just format it so that it is indistinguishable from the rest. First off, make sure that the subform has no headers. Then size the subform itself to just the size of the control that shows the value. Then set the subform control's Special Effect property to FLAT and Border to TRANSPARENT.