How to hide the initial characters in an Access ListBox?
I have an Access 2007 application.
In it, I have a number of personnel and training reports.
The personnel reports are named like this: (p) All Personnel; and the training reports are named like this: (t) All Training for All Members.
I have put this "(p) " prefix on all the personnel reports and this (t) " prefix for all the training reports.
I did this so I could distinguist each type of report so it could be selected to be displayed in it's own listbox.
I use this query, in the Row Source of the listbox, to only select the personnel reports.
SELECT [MsysObjects].[Name], [MsysObjects].[Name] FROM MsysObjects WHERE ((([MsysObjects].[Name]) Not Like "~*" And ([MsysObjects].[Name]) Not Like "MSys*") And (([MsysObjects].[Name]) Like "(p)*") And (([MsysObjects].[Type])=-32764)) ORDER BY [MsysObjects].[Name];
This query successfully selects all the personnel reports and displays them in the listbox.
Now, when the personnel report is listed in the listbox, the report is displayed exactly as I named it, including the identifying prefix "(p) ", that I used to aid the selection process.
Obviously, I don't want the users to see the report listed with the prefix. I want to only display the report name without the prefix.
So, how do I not display the prefix in the listbox but keep it as the actual report name so I can use the prefix in my selection queries?
This is the way the report is displayed in the listbox now... (p) All Personnel.
I would just like it to read... All Personnel
I believe that the answer may involve a text manipulation expression that ignores the first 4 characters of the report name: open parentheses, t or p, closed parenthesis, and one space.
If so, what is the expression and exactly where do I put it in the query.
Or, maybe you have a better solution.