Cambiar el tipo de control de un campo Boolean en Access si has elegido casilla antes.

Access tiene un comportamiento extraño en los campos de tipo Boolean cuando eliges el tipo de control casilla. En Access 2013 este control se pone por defecto (lo que lo hace más complicado) y en Access 2010 o 2016 pasa si escoges “casilla” y luego quieres volver a otro modo. No te deja volver a cambiar a Texto o Cuadro Combinado.

No parece que debiera ser así, si los valores los guarda como -1 (si/verdadero/casilla marcada) o 0 (no/falso/casilla desmarcada), debería dejar cambiar de uno a otro. Pero no es así.

Os enseñamos un truco con el que podéis poder volver a mostrar texto en vuestros campos Boolean.

 

Os recomendamos los siguientes productos relacionados con la informática:

 

Repetidor WiFi,Amplificador señal WiFi Potente,6 Antenas,2 Puertos LAN,repetidor WiFi Largo Alcance,Extensor WiFi para el Hogar y la Oficina,Fácil de Instalar,Amplificador WiFi Potente (Negro)

(5)

34,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

FECLYDET Tablet 10 Pulgadas, Android 14 Tablet Octa-Core con 10GB RAM+128GB ROM(1TB TF), Widevine L1,Bluetooth 5.0, Cámara Dual, 5000mAh, WiFi6 (Gris)

(105)

79,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

HP 302 X4D37AE, Pack de 2, Cartuchos de Tinta Originales Negro y Tricolor, compatible con impresoras de inyección de tinta HP DeskJet 1110, 2130, 3630, HP ENVY 4520, HP OfficeJet 3830, 4650 y 5220

(87019)

38,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

SanDisk 128GB Ultra, Tarjeta de memoria microSDXC, hasta 140 MB/s + adaptador SD, con Clase A1 de rendimiento de las aplicaciones, UHS-I Class 10 U1

(92635)

14,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

SanDisk 64 GB Cruzer Blade USB 2.0 Flash Drive - Black

(280557)

5,69 € (as of 20 noviembre, 2024 08:43 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Lexar 633x Tarjeta Micro SD 128 GB, Tarjeta Memoria microSDXC UHS-I, con Adaptador SD, hasta 100 MB/s de Lectura, A1, C10, U3, V30, Tarjeta TF para Smartphone, Tablet y Camara IP (LMS0633128G-BNAAA)

(14761)

10,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

TP-Link LS105G - Switch Ethernet 5 Puertos (10/100/1000Mbps), Switch Gigabit, Switch WiFi, Carcasa metálica, Ultraligero, Disipación de Calor, QoS, Ahorro de Energía, Silencioso, No Gestionado, Azul

(18819)

14,99 € (as of 20 noviembre, 2024 08:43 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Bamkey Cable USB C a Lightning 2M 2Pack[MFi Certificado], iPhone USB C Cable Lightning Cargador iPhone Carga Rapida iPhone Charger Cable Tipo C para iPhone 14 Pro Max/Plus/13/12/11/XS/8/7/6/iPad/iPod

(38)

7,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Mochila antirrobo para laptop, mochila de viaje de negocios con bloqueo de puerto de carga USB, resistente al agua, mochila de trabajo para hombres y mujeres, se adapta a portátiles de 15.6 pulgadas,

(14094)

39,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Huawei WiFi BE3, Router de Wi-Fi 7 de Doble Banda BE3600, Velocidades ultrarrápidas, Puerto Ethernet 2.5G, EasySetting, Diagnóstico Visual de Wi-Fi, Control Parental, HomeSec

(133)

69,99 € (as of 20 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)