August 13, 200322 yr 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
August 13, 200322 yr 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.
August 13, 200322 yr Author 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
Create an account or sign in to comment