Hi, On Sat, Nov 10, 2012 at 11:03:12AM +0100, Andreas Säger wrote: > > i have been trying to get empty fields to not leave blank lines. > > I have got it working with fields like Town but when the field name > > has a space in it, like' Street Address 1' I cant work out how to > > refer to field. > > > > I have been using Insert->Section and checking Hide. in the 'With > > Condition' field I have been adding 'city eq ""' but how do I refer > > to 'Street Address 1', I think it is the space that is causeing the > > problem. > > > > Ben > > > > Then the question is how the space gets into the field. The field is > not empty if there is a space so the rule which hides the entire field > does not apply. Which is the type of database you are connected to? > Hit F4, right-click the data source icon and choose "Edit Database > File". The status bar of the database window indicates where the data > come from.
If I understood Ben, he has a problem not with the content of the field/underlying DB record, but with the name of the field in the condition, for example "Database 1.Some table. Street Address 1"; according to the online help, "Conditions and Database Fields": When you refer to a database field in a condition, use the form Databasename.Tablename.Fieldname. If one of the names contains a character that is an operator, such as a minus sign (-), enclose the name in square brackets, for example, Databasename.[Table-name].Fieldname. Never use spaces inside field names. It seems he has to use [] to surround database/table/column names with spaces: [Database 1].[Some table].[Street Address 1] I didn't try it at home, so I'm not sure if it's like this. Then he may face the problem that some databases fill empty records with blanks. Regards -- Ariel Constenla-Haile La Plata, Argentina
pgp18yU16kHdZ.pgp
Description: PGP signature
