• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

User Defined Data Type, Like Boolean but with three options

Here are some easy points for someone, I'm sure.

I want to decalre a new datatype to operate like Boolean does, but I need three options instead of two.

Public Type LogOpt
    'The three options are:
       1. OpenNow (integer value 1)
       2. CloseNow (integer value 2)
       3. OpenCloseNow (integer value 3)
End Type

What is code to Declare this user defined data type?

Cheers.
0
Carl Sudholz
Asked:
Carl Sudholz
  • 2
1 Solution
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Enum Statement
Declares a type for an enumeration.

Syntax
[Public | Private] Enum name
membername [= constantexpression]
membername [= constantexpression]
. . .
End Enum
0
 
Carl SudholzAuthor Commented:
Provided the Syntax of for Enumeration which made me think a bit.  But probably a better solution becuase I learned more.
0
 
Carl SudholzAuthor Commented:
Thats what I was looking for.

Thanks
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now