How Do I Limit the display in a text box to only 1 decimal place. The query from which it is pulling its data only has 2 decimal places but when the text box fills it goes out to 8 decimal places. I have the text box formated for "fixed" with 1 decimal place. Any suggestions
accessuserva
I have a form from which I run a query based on info from selected text boxes in the form. I have a list box in which I would like the results from the query to show up in.
My listbox parameters are:
Listbox name=searchresults
Control Source:[qrysitedistance]![sitename]
Row Source Type...
I have a form with a list box in it to be filled with data after a guery is run from the form
Private Sub Search_Radius_Exit(Cancel As Integer)
Dim stDocName As String
stDocName = "qrySitedistance"
DoCmd.OpenQuery stDocName, acNormal, acEdit
Exit_Command212_Click:
Exit...
I have a combobox that I want to populate with specific data from a query after it is run. The query runs fine though it pops up in front of my form...but the combobox remains unfilled.
I have the Rowsourcetype set to qry/table & the Rowsource set to the specific query. The query is not run...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.