| Title: | Access 2000 and Leading 0's |
| Date: | 04/30/04 (12 Posts) |
| Summary: | How can you prevent Access from discarding leading zeros in a zip code field? Change the datatype from number to text. This is especially important since non-U.S. zip codes often include alphanumeric characters. But if you're only working with U.S. zip codes and have restricted user input to a 5-digit entry, you can set the format of a long integer field to "00000" to retain leading zeros. |
| Title: | Webservice Limits |
| Date: | 04/30/04 (3 Posts) |
| Summary: | Wondering how to get the best performance from query data exchanged between remote servers? Try using a web service and thin arrays. |