Default Values 0 to ""

[troix]

I have about 250 fields (this is one momma of a database). Is there a RAPID way in the table to change all the 0's to "" (empty set)?

 

[TheAceMan1]

How are ya troix . . . . .

Have you tried an [blue]Update Query[/blue]?

See Ya! . . . . . .

 

[troix]

There is no query yet.

Just the table. and all the default values are "0". I want NO default.

 

[scottian]

try some overtime...
i dont think there is a way to change default values (table field properties) using code

sorry for the glib remark

"My God! It's full of stars...

 

[troix]

well, it's not glib, it's just true. *sigh* Why doesn't Microsoft make it where you can have NO default?

 

[PHV]

Have you considered the DefaultValue property of the Field object, member of the Fields collection of the TableDef object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[scottian]

PHV

can you ellaborate on that?
sounds like you know what you are talking about and sounds like a timesaver

"My God! It's full of stars...

 

[PHV]

Tip: you have to reference the Microsoft DAO 3.x Object library.
Then feel free to play with the <F2> and <F1> keys.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[KenReay]

Hi

You do not mention if the fields in question are of type text, or number. If there are of type text, you can set the default value in the table definition (in design view) to "" instead of zero.

From your description of the problem I take it that all 250 fields are in one table? (question table design here?).

You can manipulate table design in code, using (as PVH says) the tabledef object of the DAO library

Also you can use DDL SQL commands (ALTER TABLE etc)




Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK