Format a Column in ListBox as Currency

I have the following RowSource set to a listbox:

Me.List248.RowSource = "SELECT Products_PackageDetail.ProductID as [ID], Products_Main.Name, Products_Main.Price FROM Products_PackageDetail INNER JOIN Products_Main ON Products_PackageDetail.ProductID = Products_Main.Product_ID"

I want to force the Products_Main.Price to appear as a currency, with the $ sign in front and everything.
I also have a textbox that retrieves a numerical value

Me.text1.value = "$" & Dlookup("[Price]", "Products_Main", "[Product_ID] = """ & Product_ID & """")
the price does not show up as currency - just as a number, so that is why I put the $ in front. How do I force the Dlookup result to show as currecy. Start Free Trial