Option group and stored value

[Lyncroft]

Very basic question this (and quite possibly a stupid one). When you have an option group is it usual to have that stored as a Number data type or is it okay to leave it as text type? I ask because on some databases I've seen it's stored as text but I'm thinking that it really ought to be stored as number.

 

[Hayley Baxter]

Hi Dominic

How are you today?

Here is a note from Access Help on this matter:

The OptionValue or Value property is set to a number because the value of an option group can only be a number, not text. Access stores this number in the underlying table.

HTH
Hayley

 

[Lyncroft]

Hi Hayley

I'm fine, thanks for that. I really ought to have found that myself! Naughty naughty.

Speak to you later.

Dominic

 

[Hayley Baxter]

No trouble - We all know you're just lazy (just kidding)

Speak to you soon
Hay