You probably need to test for Null fields, not just zero-length string ("") tests or empty string tests
- and you shouldn't need Conditional IIF statements for a results page displaying record field values of a recordset (a std IF Then
Else should work for each record)
|I am trying to populate a field on a results page. However the query is
| linked to a SQL table that I can't change. I was able to get the number
| field to work by using "Compatible Price: IIf([cap-Price]="
| ","NA",([cap-Price]))" but the text field must be defined differntly because
| this doesn't work "Compatible: IIf([dbo_imitmidx_sql].[user_def_fld_3]="
| ","Coming Soon",([dbo_imitmidx_sql].[user_def_fld_3]))"
| Any ideas?
|
| "Thomas A. Rowe" wrote:
|
| > However Paul M, solution would also solve the problem, as the fields would never be empty, therefore
| > no test (IF statement) would be need to determine if the field is empty
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > ==============================================
| > If you feel your current issue is a results of installing
| > a Service Pack or security update, please contact
| > Microsoft Product Support Services:
| >
http://support.microsoft.com
| > If the problem can be shown to have been caused by a
| > security update, then there is usually no charge for the call.
| > ==============================================
| >
| > | > >I believe he is asking how to populate the field on a query results page, not populate the database
| > >field during an update.
| > >
| > > --
| > > ~ Kathleen Anderson
| > > Microsoft MVP - FrontPage
| > > Spider Web Woman Designs
| > > web:
http://www.spiderwebwoman.com/resources/
| > >
| > >
| > >> Hi
| > >> You can open the database table in access click on the veiw button (top left)and set the
| > >> default to 0 for number fields or text for text fields if you use text put the text in quotes
| > >> "Call". then when the database is being populated if nothing is entered into the field it will
| > >> display the default
| > >> Paul M
| > >> | > >>>I have an Access database query that feeds a frontpage web site. I have a
| > >>> text field and a Currency field. My question is there a way to populate a
| > >>> default value when the field is blank. For example in the text field when
| > >>> blank display" Call" and in the Currency field dispaly "0".
| > >>>
| > >>> Thanks in advance for your help!
| > >>
| > >>
| > >
| > >
| >
| >
| >
