Re: Select Case on a text-field

Article View: comp.databases.ms-access

Article #215

Back to comp.databases.ms-access Previous Next

#215

From: Bruce M. Thompson
Date: Mon, 24 Nov 2003 16:40

26 lines
1711 bytes

> Selecet Case Description
> Case Null
> Print #1, presentation1
> Case Else
> Print #1, presentation2
> End Select
>
>
> This Case-statement doesn't work because it doesn't recognize when the field
> Description is empty.
>
> My question is how to write the Case-statement so it will recognize when an
> text-field in a record is empty.

'***
Select Case [Description] & ""
    Case ""
        ...
'***

:-)
-- 
Bruce M. Thompson, Microsoft Access MVP
bthmpson@mvps.org (See the Access FAQ at http://www.mvps.org/access)
>> NO Email Please. Keep all communications
     within the newsgroups so that all might benefit.<<

Technical Details

Message-ID: <vs4d3q2v7io47f@corp.supernews.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail

References: <bpt3bt$m8b$1@news1.tilbu1.nb.home.nl>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 102b1d,d0a74dd2efedac51
X-Google-Attributes: gid102b1d,public
X-Google-Thread: 11387c,d0a74dd2efedac51
X-Google-Attributes: gid11387c,public
X-Google-Thread: ff0ac,d0a74dd2efedac51
X-Google-Attributes: gidff0ac,public
X-Google-ArrivalTime: 2003-11-24 08:41:18 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: "Bruce M. Thompson" <bthmpson@big_NOSPAM_foot.com>
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,dk.edb.database.ms-access
Subject: Re: Select Case on a text-field
Date: Mon, 24 Nov 2003 11:40:22 -0500
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <vs4d3q2v7io47f@corp.supernews.com>
References: <bpt3bt$m8b$1@news1.tilbu1.nb.home.nl>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Complaints-To: abuse@supernews.com
Lines: 28

Reply to Parent Message