sero lenght primary key

S

shrive22

Board Regular
Joined
Jun 10, 2002
Messages
120
Does anyone know how to set access to allow a blank to be a zero lenght string instead of a NULL so that attribute can be part of my primary key??

thanks
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
Try the Nz function. nz([YourField],0)


The zero is the value if the field is "null" Search help in access for this function.

Ziggy
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Solved
Primary Key versus Foreign Key
2
Replies
14
Views
1K
jackd
J
C
  • Question
Updating to “0” on blanks
Replies
6
Views
243
Joe4
Joe4
K
  • Solved
Changing Primary key to new field
Replies
5
Views
480
Micron
M
JenniferMurphy
  • Question
How to structure a variable product rating database
Replies
5
Views
818
mdmilner
M
CPGDeveloper
  • Question
Error Messages and Best Practices
Replies
5
Views
330
Micron
M

Forum statistics

Threads
1,221,531
Messages
6,160,379
Members
451,642
Latest member
mirofa

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top