Query Doesn't Keep Format in ListBox

jcruzAME

Registered User.
Local time
Yesterday, 20:11
Joined
Oct 5, 2011
Messages
135
In the query I have, I have a couple columns that are formatted to standard and percent, but when I set the record source in the list box:

SELECT [qryInvestmentsofAdvisor].[ClientID], [qryInvestmentsofAdvisor].[AssetLiabilityID], [qryInvestmentsofAdvisor].[ClientName], [qryInvestmentsofAdvisor].[NetWorthToday], [qryInvestmentsofAdvisor].[FirmContactID], [qryInvestmentsofAdvisor].[90Change], [qryInvestmentsofAdvisor].[365Change] FROM qryInvestmentsofAdvisor WHERE (((qryInvestmentsofAdvisor.FirmContactID) = [Forms]![frmMainMenu].[Controls]![cboAdvisorInitials])) ORDER BY qryInvestmentsofAdvisor.ClientName;

It doesn't keep the formatting.

The thing is I have another query and list box combo on another tab of this navigation form and it works correctly, and is doing pretty much the same exact thing as I want this one too.
 

Users who are viewing this thread

Back
Top Bottom