X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Record Level Vs Column Level, Access 2010    
post Oct 16 2019, 03:56 PM

Posts: 33
Joined: 3-April 08

Can some explain or provide some links on the differences between record level and Column level validation and how to distinguish which is which.
Go to the top of the page
post Oct 16 2019, 04:24 PM

UtterAccess VIP
Posts: 7,134
Joined: 30-June 11

I've never heard of either. Can you provide some context please?

You don't perform validation in queries, but rather forms are the place for that normally.

Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
tina t
post Oct 16 2019, 04:39 PM

Posts: 6,361
Joined: 11-November 10
From: SoCal, USA

wondering if you meant to post your question in the Excel forum, rather than the Access forum?


"the wheel never stops turning"
Go to the top of the page
post Oct 16 2019, 04:42 PM

UtterAccess VIP
Posts: 11,595
Joined: 10-February 04
From: South Charleston, WV

I'm thinking record level may be referring to the table definition. For example, a required field could be defined in the table itself as opposed to on the data entry form.

I think the preferred method is keep the logic in the table itself to a minimum.

Robert Crouser
Go to the top of the page
post Oct 16 2019, 06:25 PM

UtterAccess VIP
Posts: 2,185
Joined: 4-June 18
From: Somerset, UK

Perhaps you mean record or field validation?

Colin (Mendip Data Systems)
Website, email
Go to the top of the page
post Oct 16 2019, 06:25 PM

Posts: 2,049
Joined: 10-February 08
From: Ottawa, Ont, Canada; West Palm Beach, FL

I agree that more context, or a sample showing readers what you are dealing with, would be helpful.

Good luck with your project!
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    20th February 2020 - 10:22 PM