I have two - hopefully - quick questions: Firstly, why on a form in v6.5++ for Windows does the date field _seem_ to have to be approximately twice the size that it should have to be?
For example: I have the date display format set to "WWW+ DD MMM+ YYYY" which at the R:> prompt, for today, gives "Monday 15 October 2001" - perfect and as expected. However, on a form I have to place a field that is nearly twice the size that is taken up by the row of ***** that is produced when the field is too small before I get the date displayed properly. The box is then half-empty something like this: ----------------------------------------------------- | Monday 15 October 2001 | ----------------------------------------------------- If I make the box only fractionally smaller I get something like this: -------------------------------------------------- | *************************** | -------------------------------------------------- Secondly, when using the function IFNULL I want to return a null in a variable if the tested column is null and perform a calculation if it is not null. If I use (IFNULL(Column, -0-, (Column + 2) )) I get an error or with (IFNULL(Column, Null, (Column + 2) )) I get a zero when the column is null and the calculation is fine when the column is not null. The column is actually a date column and the calculation is slightly more complicated than the example and returns an integer. I want to display nothing in the variable field if there is nothing in the column and only show the result when there is one. Any ideas anybody? Thanks in advance for any enlightenment, Regards, Alastair. A D B Burr, St. Albans, UK
