That just means you have too much money! ;-)
Make the field wider.
What do you see when you click in the field?
From your description, there is also some uncertainty about whether you have placed a field from the correct table occurrence.
ha, that worked. Geez. I can't believe that it doesn't display as "..." or the number being cut off.
One more thing. I can 'find' the dates by year with my script, but it it adds fields that have blank date fields as well. How do I not find those entries?
If you have s script that doesn't work, the first thing to do is post the script. Unfortunately this forum doesn't allow attachments though, which is bizarre and counter to the whole purpose of the forum but … anyway.
the script is simply (*/*/2013)
When I put that in it shows up the dates that are only for that year but also records that are blank in the date field. I am simply trying to omit those blank fields from the 'find'.
1. That is not a script.
2. What is the COMPLETE script?
3. I don't think the result you describe is possible.
Whoops, I'm sorry. I'm talking about a button function. When I go to set up a button function I am having it perform a find and then I specify that it find entries based on date, and that criteria is (*/*/2013)
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post a New Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here. (with this approach, you can get multiple script steps on the same line, please edit the pasted text by inserting some returns to separate those steps.)
- If You have FileMaker Advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format.
Try just entering 2013 as your search criteria. No need for the wild cards for day and month.
Make sure that this is a field of type date and not a field of type text.
The field is a date set as 12/25/2003 - but that is all formatting... I did just enter 2013 as the criteria but it always posts it as */*/2013. Also, I added a criteria for the payment status field too be 'Paid' (It can only read 'Paid' and 'Unpaid') the entries with a blank date should come up as 'Unpaid' but this doesn't seem to have any effect.
A screen shot showing the exact and complete criteria used would be helpful. We might spot an issue in what you are specifying or it might lead someone to ask just the right question in order to lead you to the answer.
I also suggest testing whether you can enter find mode, manually specify this criteria and then be able to find the correct set of records.
This thread of scripted find examples may also be helpful: Scripted Find Examples
+1 for Phil's comments and suggestion for scripted finds.
This is yet another reason why a real, properly written script, with explicit scripted finds, is much preferable.
You can actually read, troubleshoot, and if necessary post the script.