I have an Access database of about 200 mb. Suddenly all the check boxes were
changed for unknown reason to text boxes. Efforts to restore from the table
using Lookup fail. The change will be made and when you exit the table and
return, it has been changed back to a text box. Tried using Format/change
to, but the "check box" menu option is grayed out. Ideas please?

Are you saying that the table definition has changed from a Yes/No field to
a text field?

Or are you saying that what is displayed (?where, on a form?) is changed?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Rumple41" <(E-Mail Removed)> wrote in message
news:5D41AB2A-0551-4294-9ADD-(E-Mail Removed)...
>I have an Access database of about 200 mb. Suddenly all the check boxes
>were
> changed for unknown reason to text boxes. Efforts to restore from the
> table
> using Lookup fail. The change will be made and when you exit the table and
> return, it has been changed back to a text box. Tried using Format/change
> to, but the "check box" menu option is grayed out. Ideas please?

Jeff:

Thanks for your response. The answer to your question is: The change is
made in the definitions table. It worked fine for several months and then
suddenly, no check boxes. I changed it back to a check box in the table
definition, but after exiting and reentering the table I found it had been
changed back.

Any help will be appreciated.

Rumple41 ((E-Mail Removed))

"Jeff Boyce" wrote:

> Are you saying that the table definition has changed from a Yes/No field to
> a text field?
>
> Or are you saying that what is displayed (?where, on a form?) is changed?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Rumple41" <(E-Mail Removed)> wrote in message
> news:5D41AB2A-0551-4294-9ADD-(E-Mail Removed)...
> >I have an Access database of about 200 mb. Suddenly all the check boxes
> >were
> > changed for unknown reason to text boxes. Efforts to restore from the
> > table
> > using Lookup fail. The change will be made and when you exit the table and
> > return, it has been changed back to a text box. Tried using Format/change
> > to, but the "check box" menu option is grayed out. Ideas please?
>
>
>

Thanks for your response. The answer to your question is: The change is
made in the definitions table. It worked fine for several months and then
suddenly, no check boxes. I changed it back to a check box in the table
definition, but after exiting and reentering the table I found it had been
changed back.

Any help will be appreciated.


"Jeff Boyce" wrote:

> Are you saying that the table definition has changed from a Yes/No field to
> a text field?
>
> Or are you saying that what is displayed (?where, on a form?) is changed?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Rumple41" <(E-Mail Removed)> wrote in message
> news:5D41AB2A-0551-4294-9ADD-(E-Mail Removed)...
> >I have an Access database of about 200 mb. Suddenly all the check boxes
> >were
> > changed for unknown reason to text boxes. Efforts to restore from the
> > table
> > using Lookup fail. The change will be made and when you exit the table and
> > return, it has been changed back to a text box. Tried using Format/change
> > to, but the "check box" menu option is grayed out. Ideas please?
>
>
>

As far as I know, tables don't have "check boxes" as a data type. Tables
can display a checkbox for a yes/no data type. Have you checked the data
type, to see if it changed?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Rumple41" <(E-Mail Removed)> wrote in message
news:BA6F4EA9-8D22-4BCA-8CBF-(E-Mail Removed)...
> Thanks for your response. The answer to your question is: The change is
> made in the definitions table. It worked fine for several months and then
> suddenly, no check boxes. I changed it back to a check box in the table
> definition, but after exiting and reentering the table I found it had been
> changed back.
>
> Any help will be appreciated.
>
>
> "Jeff Boyce" wrote:
>
>> Are you saying that the table definition has changed from a Yes/No field
>> to
>> a text field?
>>
>> Or are you saying that what is displayed (?where, on a form?) is changed?
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "Rumple41" <(E-Mail Removed)> wrote in message
>> news:5D41AB2A-0551-4294-9ADD-(E-Mail Removed)...
>> >I have an Access database of about 200 mb. Suddenly all the check boxes
>> >were
>> > changed for unknown reason to text boxes. Efforts to restore from the
>> > table
>> > using Lookup fail. The change will be made and when you exit the table
>> > and
>> > return, it has been changed back to a text box. Tried using
>> > Format/change
>> > to, but the "check box" menu option is grayed out. Ideas please?
>>
>>
>>

Jeff:

Thanks for your response. Of course you are right and I apologize for not
using the correct syntax. The fields I am talking about were orginally
yes/no data types, but inexplicably changed by the "gremlin" to text data
type. I changed them back and they showed ok in the design view of the table.
But when I exit the table and then return to the design view, the "gremlin"
has changed them back. Further, there are numerous yes/no data types in this
table, but only some of them are changing. All new fields with data type
"yes/no" are changed by the "gremlin" to text boxes upon closing the table.
This is maddening and will be unusable by my client if I can't get this fixed
before the data entry is finished. Thanks again for any suggestions.
Rumple41 (Jim)

"Jeff Boyce" wrote:

> As far as I know, tables don't have "check boxes" as a data type. Tables
> can display a checkbox for a yes/no data type. Have you checked the data
> type, to see if it changed?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Rumple41" <(E-Mail Removed)> wrote in message
> news:BA6F4EA9-8D22-4BCA-8CBF-(E-Mail Removed)...
> > Thanks for your response. The answer to your question is: The change is
> > made in the definitions table. It worked fine for several months and then
> > suddenly, no check boxes. I changed it back to a check box in the table
> > definition, but after exiting and reentering the table I found it had been
> > changed back.
> >
> > Any help will be appreciated.
> >
> >
> > "Jeff Boyce" wrote:
> >
> >> Are you saying that the table definition has changed from a Yes/No field
> >> to
> >> a text field?
> >>
> >> Or are you saying that what is displayed (?where, on a form?) is changed?
> >>
> >> Regards
> >>
> >> Jeff Boyce
> >> Microsoft Office/Access MVP
> >>
> >> "Rumple41" <(E-Mail Removed)> wrote in message
> >> news:5D41AB2A-0551-4294-9ADD-(E-Mail Removed)...
> >> >I have an Access database of about 200 mb. Suddenly all the check boxes
> >> >were
> >> > changed for unknown reason to text boxes. Efforts to restore from the
> >> > table
> >> > using Lookup fail. The change will be made and when you exit the table
> >> > and
> >> > return, it has been changed back to a text box. Tried using
> >> > Format/change
> >> > to, but the "check box" menu option is grayed out. Ideas please?
> >>
> >>
> >>
>
>
>

I've never had this happen, but corruption can have some strange effects. I
suggest you take a look at the information on corruption and recovering
therefrom at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr. The
end result should be a new database, with the old objects cleaned and
imported.

The following should "go without saying," but, be sure, too, that you are
up-to-date on Service Packs and updates for your version of Access -- I have
seen (rare) cases (far fewer than phone tech support might recommend) when
uninstalling Access (or Office) and reinstalling, then applying the Service
Packs and updates has been beneficial.

Larry Linson
Microsoft Office Access MVP

Jim

I'm with Larry on this ... I've not run across something like this happening
(thanks for the clarifications. My spouse accuses me of being a bit to
'literal', but if I don't understand, I can only guess <g>).

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Rumple41 (Jim)" <Rumple41 (Jim)@discussions.microsoft.com> wrote in message
news:AA3A2756-BE68-40E9-8718-(E-Mail Removed)...
> Jeff:
>
> Thanks for your response. Of course you are right and I apologize for not
> using the correct syntax. The fields I am talking about were orginally
> yes/no data types, but inexplicably changed by the "gremlin" to text data
> type. I changed them back and they showed ok in the design view of the
> table.
> But when I exit the table and then return to the design view, the
> "gremlin"
> has changed them back. Further, there are numerous yes/no data types in
> this
> table, but only some of them are changing. All new fields with data type
> "yes/no" are changed by the "gremlin" to text boxes upon closing the
> table.
> This is maddening and will be unusable by my client if I can't get this
> fixed
> before the data entry is finished. Thanks again for any suggestions.
> Rumple41 (Jim)
>
> "Jeff Boyce" wrote:
>
>> As far as I know, tables don't have "check boxes" as a data type. Tables
>> can display a checkbox for a yes/no data type. Have you checked the data
>> type, to see if it changed?
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "Rumple41" <(E-Mail Removed)> wrote in message
>> news:BA6F4EA9-8D22-4BCA-8CBF-(E-Mail Removed)...
>> > Thanks for your response. The answer to your question is: The change
>> > is
>> > made in the definitions table. It worked fine for several months and
>> > then
>> > suddenly, no check boxes. I changed it back to a check box in the table
>> > definition, but after exiting and reentering the table I found it had
>> > been
>> > changed back.
>> >
>> > Any help will be appreciated.
>> >
>> >
>> > "Jeff Boyce" wrote:
>> >
>> >> Are you saying that the table definition has changed from a Yes/No
>> >> field
>> >> to
>> >> a text field?
>> >>
>> >> Or are you saying that what is displayed (?where, on a form?) is
>> >> changed?
>> >>
>> >> Regards
>> >>
>> >> Jeff Boyce
>> >> Microsoft Office/Access MVP
>> >>
>> >> "Rumple41" <(E-Mail Removed)> wrote in message
>> >> news:5D41AB2A-0551-4294-9ADD-(E-Mail Removed)...
>> >> >I have an Access database of about 200 mb. Suddenly all the check
>> >> >boxes
>> >> >were
>> >> > changed for unknown reason to text boxes. Efforts to restore from
>> >> > the
>> >> > table
>> >> > using Lookup fail. The change will be made and when you exit the
>> >> > table
>> >> > and
>> >> > return, it has been changed back to a text box. Tried using
>> >> > Format/change
>> >> > to, but the "check box" menu option is grayed out. Ideas please?
>> >>
>> >>
>> >>
>>
>>
>>

wow it sounds to me lke you guys should stop blaming gremlins; and
start blaming that piece of **** database you still cling to.

Access (without Jet) never corrupts for me. Jet has been obsolete
for a decade.
SQL Server is the worlds most popular database.

Maybe you should get rid of Jet, instead of making excuses for a
database that easily corrupts data.

-Aaron





On Dec 8, 5:11*pm, "Larry Linson" <boun...@localhost.not> wrote:
> I've never had this happen, butcorruptioncan have some strange effects. I
> suggest you take a look at the information oncorruptionand recovering
> therefrom at MVP Tony Toews' site,http://www.granite.ab.ca/accsmstr. *The
> end result should be a new database, with the old objects cleaned and
> imported.
>
> The following should "go without saying," but, be sure, too, that you are
> up-to-date on Service Packs and updates for your version of Access -- I have
> seen (rare) cases (far fewer than phone tech support might recommend) when
> uninstalling Access (or Office) and reinstalling, then applying the Service
> Packs and updates has been beneficial.
>
> *Larry Linson
> *Microsoft Office Access MVP