csbalogh Posted August 13, 2003 Posted August 13, 2003 Hello, I have a field which is formatted as value list (strict, do not allow modification). Some of the values also contain a question mark (among other characters). When I want to perform a find and I select an item from the value list, which contains such a question mark I get the message that the field value I've choosen as a find criteria is invalid (accept this value does not work). Why is that, and how can I avoid it? Thanks. csb
danjacoby Posted August 13, 2003 Posted August 13, 2003 In find mode, a question mark means "invalid date or time". It's in the list of symbols that show up in the status bar when in find mode. Basically, the answer is not to use the question mark in find mode. Just look up the rest of the value.
csbalogh Posted August 13, 2003 Author Posted August 13, 2003 My problem is that the question mark formes part of a record. So I have a value list containing a value which looks like: What happened to Herodotus? Problems of Classical History. Say this is a book, which is a collection of essays. I have a database where I record all the individual essays in different recrods, and select as source title for each record the book title above. When I want to filter all records that belong to the same book I choose the title via a script from the value list (returns all articles that are to be found in the same book). The problem however appears when the title (which is used in the filter function) contains a question mark. Since the filtering is automated I am not able to change the value that FM is about to filter. Do I have to include a line in the script to tell how to handle those records from the value list, which contain a "?" ? csb
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now