在数据输入期间标准化数据？ [英] Normalize data during data entry?

问题描述

我是FileMaker用户尝试帮助客户端解决Access数据输入问题：


从其他应用程序复制文本并粘贴到Access表单时，粘贴的文本有时包括不需要的字符（例如，前导或尾随空格，嵌入式回车符，标点符号）。


我们想要自动规范化粘贴的文本。我知道如何在FileMaker中执行此操作 - 执行自动输入计算，用计算的（标准化）值替换新输入/修改的值。


Access是否提供了数据输入期间任意规范化的钩子？

I''m a FileMaker user trying to help a client with an Access data entry problem:

When text is copied from another application and pasted into an Access form, the pasted text sometimes includes unwanted characters (e.g., leading or trailing whitespace, embedded carriage returns, punctuation).

We''d like to automatically normalize the pasted text. I know how I''d do this in FileMaker - perform an Auto-Enter calculation that replaces the newly entered/modified value with a computed (normalized) value.

Does Access provide a hook for arbitrary normalization during data entry?

推荐答案

您可以使用trim（）修剪内容之前和之后的所有空格。或InStr（）如果还有其他字符可以摆脱。

You could use trim() to trim all the spaces before and after the content. Or InStr() if there are other characters to get rid of.

Replace（）可能对你更好，但我不认为有标准的设置或功能要做适合你的工作。

Replace() may work better for you but I don''t think there''s a standard setting or function to do the job for you.

我是FileMaker用户试图帮助客户解决Access数据输入问题：


当文本从另一个应用程序复制并粘贴到Access表单中时，粘贴的文本有时会包含不需要的字符（例如，前导或尾随空格，嵌入式回车符，标点符号）。


我们想要自动规范化粘贴的文本。我知道如何在FileMaker中执行此操作 - 执行自动输入计算，用计算的（标准化）值替换新输入/修改的值。


Access是否提供了数据输入期间任意归一化的钩子？

I''m a FileMaker user trying to help a client with an Access data entry problem:

When text is copied from another application and pasted into an Access form, the pasted text sometimes includes unwanted characters (e.g., leading or trailing whitespace, embedded carriage returns, punctuation).

We''d like to automatically normalize the pasted text. I know how I''d do this in FileMaker - perform an Auto-Enter calculation that replaces the newly entered/modified value with a computed (normalized) value.

Does Access provide a hook for arbitrary normalization during data entry?

简单回答不是在复制和粘贴数据时。但是，可以使用更新后事件对数据进行标准化。我将首先使用trim函数来消除空格，然后使用repace函数进行操作，这些函数会查找回车符，制表符等，并用"替换它们。一个空字符。


Mary

Simple answer is not when data is being copied and pasted. However the data can be normalised using the after update event. I would use the trim function first to eliminate whitespace and follow this with repace functions which would look for carriage returns, tab characters, etc and replace them with "" a null character.

Mary

这篇关于在数据输入期间标准化数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！