By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Access2k with SQL Server2k backend: yes/no fields and date input masks, how?

P: n/a
Hello all,
I have an Access database linked to SQL Server tables and Views.

When I upsized the Access tables all the yes/no fields remained the
same, i.e., I see a check mark or not. When I create a yes/no field in
SQL Server, I see a 1 or a 0. I would like the new SQL server fields
to show me a check mark in the Access front-end. Is there any way of
doing this?

Also, for data entry purposes, I need to be able to enter mm/yyyy and
have the slash there automatically. It seems like SQL Server will not
let me do it. Can anyone tell me if it is possible, and how to do it?

I appreciate all the help I can get!!

Thanks,
Monica
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
A few days ago I posted the following, does anyone have an answer?
thank you!!
Hello all,
I have an Access database linked to SQL Server tables and Views.

When I upsized the Access tables all the yes/no fields remained the
same, i.e., I see a check mark or not. When I create a yes/no field in
SQL Server, I see a 1 or a 0. I would like the new SQL server fields
to show me a check mark in the Access front-end. Is there any way of
doing this?

Also, for data entry purposes, I need to be able to enter mm/yyyy and
have the slash there automatically. It seems like SQL Server will not
let me do it. Can anyone tell me if it is possible, and how to do it?

I appreciate all the help I can get!!

Thanks,
Monica

Nov 12 '05 #2

P: n/a
Monica,
My experience with SQL Server backends is limited, but...
I assume that the examples you cite are from the A2K front end. So formating
what you see is accomplished from the frontend and is not related to the
backend.

1. Yes/No fields - You claim to see 0 & 1. I suspect that you actually see 0
& -1. This is how the data is stored, 0 means false/no and -1 means
true/yes.

2. If you want to see a checkbox, then set that as the format property. If
you want to see a checkbox from the table, then set the format property of
that field in the table design. If you want to see a checkbox from a form,
then set the format property of that control in the form design.

3. If you want to enter data into the format of mm/yyyy and have the slash
appear automatically, then that is accomplished using the input mask
property, example 99/9999. Remember that this is not a date so this field
must not be defined as date. It must be defined as either numeric or text.

Fred Zuckerman
San Diego, CA, USA

"Monica Roman" <mo*********@yahoo.com> wrote in message
news:9e**************************@posting.google.c om...
A few days ago I posted the following, does anyone have an answer?
thank you!!
Hello all,
I have an Access database linked to SQL Server tables and Views.

When I upsized the Access tables all the yes/no fields remained the
same, i.e., I see a check mark or not. When I create a yes/no field in
SQL Server, I see a 1 or a 0. I would like the new SQL server fields
to show me a check mark in the Access front-end. Is there any way of
doing this?

Also, for data entry purposes, I need to be able to enter mm/yyyy and
have the slash there automatically. It seems like SQL Server will not
let me do it. Can anyone tell me if it is possible, and how to do it?

I appreciate all the help I can get!!

Thanks,
Monica

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.